I create a foreign server in postgresql. Before adding foreign table, I want to get list of tables in this foreign server.
Is there any way I can do this?
This sql query show the created foreign tables:
select * from information_schema.foreign_tables
But I want to know table names and structure before create it!