tuhelj

[zc] / fdw_file.sql

CREATE EXTENSION file_fdw;

CREATE SERVER sub FOREIGN DATA WRAPPER file_fdw;

CREATE FOREIGN TABLE sub (
        sub text,
        pn bigint,
        imei text,
        name text
)
SERVER sub
OPTIONS ( filename '/home/dpavlin/zc/subvision-numbers.txt', format 'csv', delimiter ' ' );