Postgresql外部表使用 postgres_fdw

create extension postgres_fdw;create server server_remote_db foreign data wrapper postgres_fdw options(host '10.10.10.10',port '7788',dbname 'test_db');create user mapping for test_role_user server_remote_db options(user 'test_role',password 'test_role');grant all on foreign server server_remote_db to test_role;import foreign schema public from server server_remote_db into public;