add sub table for subvision-numbers.txt

diff --git a/fdw_file.sql b/fdw_file.sql
new file mode 100644 (file)
index 0000000..92788e8
--- /dev/null
+++ b/fdw_file.sql
@@ -0,0 +1,12 @@
+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 ' ' );