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
Last activity: Feb 28, 2025, 07:00 PM