From f0783ab8483fc7748757290a2117147ee39c1db2 Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Thu, 22 Dec 2022 11:50:03 +0100
Subject: [PATCH] add sub table for subvision-numbers.txt

---
 fdw_file.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 fdw_file.sql

diff --git a/fdw_file.sql b/fdw_file.sql
new file mode 100644
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 ' ' );
-- 
2.20.1