Postgres95 1.01 Distribution - Virgin SourcesPG95-1_01

1 files changed, 18 insertions, 0 deletions

diff --git a/src/test/suite/quote.sql b/src/test/suite/quote.sql
new file mode 100644
index 0000000000..0040bebb9b
--- /dev/null
+++ b/src/test/suite/quote.sql
@@ -0,0 +1,18 @@
+create table quoteTBL (f text);
+
+insert into quoteTBL values ('hello world');
+insert into quoteTBL values ('hello '' world');
+insert into quoteTBL values ('hello \' world');
+insert into quoteTBL values ('hello \\ world');
+insert into quoteTBL values ('hello \t world');
+insert into quoteTBL values ('hello
+world
+with 
+newlines
+');
+insert into quoteTBL values ('hello " world');
+insert into quoteTBL values ('');
+  -- bad escape sequence 
+insert into quoteTBL values ('hello \y world');  
+select * from quoteTBL;
+drop table quoteTBL;