Hi,
I'm trying to query tables from postgres database. All tables there are under Foreign tables and nothing under tables. when I use db connect it get the schema name but it couldn't get the list of tables.
How can I access the foreign tables using db connect?
Try running the below query in the DB connect:
select * from information_schema.foreign_tables
OR
select * from information_schema.tables
Try running the below query in the DB connect:
select * from information_schema.foreign_tables
OR
select * from information_schema.tables
Thanks @VatsalJagani it works fine.
Actually it was a stupid question, but it was going on the opposite direction all the time and couldn't think good 🙂