---- COPY---- CLASS POPULATION--	(any resemblance to real life is purely coincidental)--COPY aggtest FROM '@abs_srcdir@/data/agg.data';COPY onek FROM '@abs_srcdir@/data/onek.data';COPY onek TO '@abs_builddir@/results/onek.data';DELETE FROM onek;COPY onek FROM '@abs_builddir@/results/onek.data';COPY tenk1 FROM '@abs_srcdir@/data/tenk.data';COPY slow_emp4000 FROM '@abs_srcdir@/data/rect.data';COPY person FROM '@abs_srcdir@/data/person.data';COPY emp FROM '@abs_srcdir@/data/emp.data';COPY student FROM '@abs_srcdir@/data/student.data';COPY stud_emp FROM '@abs_srcdir@/data/stud_emp.data';COPY road FROM '@abs_srcdir@/data/streets.data';COPY real_city FROM '@abs_srcdir@/data/real_city.data';COPY hash_i4_heap FROM '@abs_srcdir@/data/hash.data';COPY hash_name_heap FROM '@abs_srcdir@/data/hash.data';COPY hash_txt_heap FROM '@abs_srcdir@/data/hash.data';COPY hash_f8_heap FROM '@abs_srcdir@/data/hash.data';COPY test_tsvector FROM '@abs_srcdir@/data/tsearch.data';-- the data in this file has a lot of duplicates in the index key-- fields, leading to long bucket chains and lots of table expansion.-- this is therefore a stress test of the bucket overflow code (unlike-- the data in hash.data, which has unique index keys).---- COPY hash_ovfl_heap FROM '@abs_srcdir@/data/hashovfl.data';COPY bt_i4_heap FROM '@abs_srcdir@/data/desc.data';COPY bt_name_heap FROM '@abs_srcdir@/data/hash.data';COPY bt_txt_heap FROM '@abs_srcdir@/data/desc.data';COPY bt_f8_heap FROM '@abs_srcdir@/data/hash.data';COPY array_op_test FROM '@abs_srcdir@/data/array.data';COPY array_index_op_test FROM '@abs_srcdir@/data/array.data';--- test copying in CSV mode with various styles--- of embedded line ending characterscreate temp table copytest (	style	text,	test 	text,	filler	int);insert into copytest values('DOS',E'abc\r\ndef',1);insert into copytest values('Unix',E'abc\ndef',2);insert into copytest values('Mac',E'abc\rdef',3);insert into copytest values(E'esc\\ape',E'a\\r\\\r\\\n\\nb',4);copy copytest to '@abs_builddir@/results/copytest.csv' csv;create temp table copytest2 (like copytest);copy copytest2 from '@abs_builddir@/results/copytest.csv' csv;select * from copytest except select * from copytest2; style | test | filler -------+------+--------(0 rows)truncate copytest2;--- same test but with an escape char different from quote charcopy copytest to '@abs_builddir@/results/copytest.csv' csv quote '''' escape E'\\';copy copytest2 from '@abs_builddir@/results/copytest.csv' csv quote '''' escape E'\\';select * from copytest except select * from copytest2; style | test | filler -------+------+--------(0 rows)-- test header line featurecreate 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,12,b,2