17 Jun 2020   sql


pg_dump will dump foreign tables schemas, but not their data.

$ pg_dump -d db_with_foreign_tables
CREATE FOREIGN TABLE public.users (
  name text,
  ...
)
SERVER foreign_server_somewhere
OPTIONS (
  query 'select * from foreign_users'
);