From 8c4da76cf3438fd80ce166681e62b617bb1a624c Mon Sep 17 00:00:00 2001 From: Neil Conway Date: Tue, 10 May 2005 00:16:07 +0000 Subject: [PATCH] Regression tests for the COPY CSV header feature. From Andrew Dunstan. --- src/test/regress/input/copy.source | 14 ++++++++++++++ src/test/regress/output/copy.source | 10 ++++++++++ 2 files changed, 24 insertions(+) diff --git a/src/test/regress/input/copy.source b/src/test/regress/input/copy.source index 184a0ec1bc..98dc272ce7 100644 --- a/src/test/regress/input/copy.source +++ b/src/test/regress/input/copy.source @@ -86,4 +86,18 @@ copy copytest2 from '@abs_builddir@/results/copytest.csv' csv quote '\'' escape select * from copytest except select * from copytest2; +-- test header line feature + +create temp table copytest3 ( + c1 int, + "col with , comma" text, + "col with "" quote" int); + +copy copytest3 from stdin csv header; +this is just a line full of junk that would error out if parsed +1,a,1 +2,b,2 +\. + +copy copytest3 to stdout csv header; diff --git a/src/test/regress/output/copy.source b/src/test/regress/output/copy.source index 35ef9dce7e..e6839d3f36 100644 --- a/src/test/regress/output/copy.source +++ b/src/test/regress/output/copy.source @@ -58,3 +58,13 @@ select * from copytest except select * from copytest2; -------+------+-------- (0 rows) +-- test header line feature +create temp table copytest3 ( + c1 int, + "col with , comma" text, + "col with "" quote" int); +copy copytest3 from stdin csv header; +copy copytest3 to stdout csv header; +c1,"col with , comma","col with "" quote" +1,a,1 +2,b,2 -- 2.40.0