pg创建外部表步骤

-- 1. 安装 postgres_fdw 扩展（如果尚未安装）

-- 2. 创建登录角色和密码
CREATE ROLE foreign_user LOGIN PASSWORD 'foreign_user_password';

-- 3. 创建外部数据映射
CREATE EXTENSION IF NOT EXISTS postgres_fdw;

-- 4. 创建服务器对象
CREATE SERVER foreign_server FOREIGN DATA WRAPPER postgres_fdw
    OPTIONS (host 'foreign_host', port '5432', dbname 'foreign_database');

-- 5. 创建用户映射
CREATE USER MAPPING FOR foreign_user
    SERVER foreign_server
    OPTIONS (user 'foreign_user', password 'foreign_user_password');

-- 6. 创建外部表
CREATE FOREIGN TABLE foreign_table (
    column1 data_type,
    column2 data_type,
    ...
) SERVER foreign_server
OPTIONS (schema_name 'public', table_name 'external_table');