summaryrefslogtreecommitdiffstats
path: root/src/test/examples/testlibpq3.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/examples/testlibpq3.sql')
-rw-r--r--src/test/examples/testlibpq3.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/test/examples/testlibpq3.sql b/src/test/examples/testlibpq3.sql
new file mode 100644
index 0000000..35a95ca
--- /dev/null
+++ b/src/test/examples/testlibpq3.sql
@@ -0,0 +1,6 @@
+CREATE SCHEMA testlibpq3;
+SET search_path = testlibpq3;
+SET standard_conforming_strings = ON;
+CREATE TABLE test1 (i int4, t text, b bytea);
+INSERT INTO test1 values (1, 'joe''s place', '\000\001\002\003\004');
+INSERT INTO test1 values (2, 'ho there', '\004\003\002\001\000');