Sample Header Ad - 728x90

How can I get list of foreign server's tables in postgresql?

0 votes
2 answers
3060 views
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!
Asked by Ali dashti (123 rep)
Sep 8, 2022, 06:47 AM
Last activity: Feb 28, 2025, 07:00 PM