replaced COPY with INSERT INTO

qgis · Nov 15, 2015 · 6ee90c3 · 6ee90c3
1 parent 824fd7b
commit 6ee90c3
Showing 1 changed file with 7 additions and 7 deletions.
diff --git a/tests/testdata/provider/testdata.sql b/tests/testdata/provider/testdata.sql
@@ -47,13 +47,13 @@ CREATE TABLE qgis_test."someData" (
 -- Data for Name: someData; Type: TABLE DATA; Schema: qgis_test; Owner: postgres
 --
 
-COPY qgis_test."someData" (pk, cnt, name, geom) FROM stdin;
-5	-200	\N	0101000020E61000001D5A643BDFC751C01F85EB51B88E5340
-3	300	Pear	\N
-1	100	Orange	0101000020E61000006891ED7C3F9551C085EB51B81E955040
-2	200	Apple	0101000020E6100000CDCCCCCCCC0C51C03333333333B35140
-4	400	Honey	0101000020E610000014AE47E17A5450C03333333333935340
-\.
+INSERT INTO qgis_test."someData" (pk, cnt, name, geom) VALUES
+(5, -200, NULL,     '0101000020E61000001D5A643BDFC751C01F85EB51B88E5340'),
+(3,  300, 'Pear',   NULL),
+(1,  100, 'Orange', '0101000020E61000006891ED7C3F9551C085EB51B81E955040'),
+(2,  200, 'Apple',  '0101000020E6100000CDCCCCCCCC0C51C03333333333B35140'),
+(4,  400, 'Honey',  '0101000020E610000014AE47E17A5450C03333333333935340')
+;
 
 
 --