blob: 3eb15b61fb73e81f818893bffba68456ec96f8e3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
COPY t FROM 'xxx';
COPY t FROM stdin;
COPY t(x,y) FROM 'xxx';
COPY t FROM 'xxx' BINARY;
COPY t FROM 'xxx' CSV HEADER QUOTE AS '#' ESCAPE AS '$' FORCE NOT NULL foo,bar;
COPY t FROM 'xxx' OIDS;
COPY t FROM 'xxx' DELIMITER ',';
COPY t FROM 'xxx' NULL 'x';
COPY t TO 'yyy';
COPY t TO stdout;
COPY t(x,y) TO 'yyy';
COPY t TO 'yyy' BINARY;
COPY t FROM 'xxx' CSV HEADER QUOTE AS '#' ESCAPE AS '$' FORCE QUOTE foo,bar;
COPY t TO 'yyy' OIDS;
COPY t TO 'yyy' DELIMITER ',';
COPY t TO 'yyy' NULL 'x';
COPY (SELECT * FROM t) TO 'xxx';
|
