How to retrieve list of foreign tables in splunk db connect?

[vanheer]

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?

[VatsalJagani · Accepted solution]

Try running the below query in the DB connect:

select * from information_schema.foreign_tables

OR 

select * from information_schema.tables

[vanheer]

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 🙂