十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
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;