summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/copy2.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/copy2.out')
-rw-r--r--src/test/regress/expected/copy2.out19
1 files changed, 19 insertions, 0 deletions
diff --git a/src/test/regress/expected/copy2.out b/src/test/regress/expected/copy2.out
index 6345969a03..6048f9392f 100644
--- a/src/test/regress/expected/copy2.out
+++ b/src/test/regress/expected/copy2.out
@@ -172,6 +172,25 @@ I'm null before trigger fired
3 after trigger fired
4 after trigger fired
5 after trigger fired
+CREATE TABLE y (
+ col1 text,
+ col2 text
+);
+INSERT INTO y VALUES ('Jackson, Sam', '\\h');
+INSERT INTO y VALUES ('It is "perfect".','\t');
+INSERT INTO y VALUES ('', NULL);
+COPY y TO stdout WITH CSV;
+"Jackson, Sam",\h
+"It is ""perfect"".",
+"",
+COPY y TO stdout WITH CSV QUOTE '''' DELIMITER '|';
+Jackson, Sam|\h
+It is "perfect".|
+''|
+COPY y TO stdout WITH CSV FORCE QUOTE col2 ESCAPE '\\';
+"Jackson, Sam","\\h"
+"It is \"perfect\"."," "
+"",
DROP TABLE x;
DROP FUNCTION fn_x_before();
DROP FUNCTION fn_x_after();