Regression tests for the COPY CSV header feature. From Andrew Dunstan.

Neil Conway · Neil Conway · commit 8c4da76cf343 · 2005-05-10T00:16:07.000Z
diff --git 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
@@ -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
