-
Notifications
You must be signed in to change notification settings - Fork 0
postgres外部表
wnh5 edited this page Oct 21, 2017
·
16 revisions
#安装file_fdw
需要先安装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 ',');