-
Notifications
You must be signed in to change notification settings - Fork 0
postgres外部表
wnh5 edited this page Oct 21, 2017
·
16 revisions
需要先安装file_fdw,一般是进到PostgreSQL的源码包中的contrib/file_fdw目录下,执行:
make
make install
然后进入数据库中,执行以下SQL把file_fdw安装上:
CREATE EXTENSION file_fdw;
CREATE SERVER file_fdw_server FOREIGN DATA WRAPPER file_fdw;
grant usage on foreign data wrapper file_fdw to liuche;
revoke usage on foreign data wrapper file_fdw from liuche;
CREATE FOREIGN TABLE test_table (
id bigint,
name Text
)
SERVER file_fdw_server
OPTIONS (format 'csv', filename '/Users/liuche/tmp/test_table.txt', delimiter ',');
- filename后面是文件名和绝对路径
- format是格式,csv是逗号分隔,text表示是tab分隔的方式
- delimiter是分隔符
- header表示第一行数据是否需要
- null表示空数据的转化处理,例子中字段1将转化为null
alter foreign table tab_area options(set null '^null*');