off fdw to offsets.txt

diff --git a/fdw_file_offset.sql b/fdw_file_offset.sql
new file mode 100644 (file)
index 0000000..c9bfca9
--- /dev/null
+++ b/fdw_file_offset.sql
@@ -0,0 +1,11 @@
+-- CREATE EXTENSION file_fdw;
+
+-- CREATE SERVER sub FOREIGN DATA WRAPPER file_fdw;
+
+CREATE FOREIGN TABLE off (
+       pn bigint,
+       x float,
+       y float
+)
+SERVER sub
+OPTIONS ( filename '/home/dpavlin/zc/gnuplot/offset.txt', format 'csv', delimiter ' ' );