3after trigger fired

4after trigger fired

5after trigger fired

CREATE TABLE y (

col1 text,

col2 text

);

INSERT INTO y VALUES ('Jackson, Sam', '\\h');

INSERT INTO y VALUES ('It is "perfect".','\t');

INSERT INTO y VALUES ('', NULL);

COPY y TO stdout WITH CSV;

"Jackson, Sam",\h

"It is ""perfect"".",

"",

COPY y TO stdout WITH CSV QUOTE '''' DELIMITER '|';

Jackson, Sam|\h

It is "perfect".|

''|

COPY y TO stdout WITH CSV FORCE QUOTE col2 ESCAPE '\\';

"Jackson, Sam","\\h"

"It is \"perfect\".",""

"",

DROP TABLE x;

DROP FUNCTION fn_x_before();

DROP FUNCTION fn_x_after();

COPY x (c, e) TO stdout;

COPY x (b, e) TO stdout WITHNULL'I''m null';

CREATETABLEy (

col1text,

col2text

);

INSERT INTO yVALUES ('Jackson, Sam','\\h');

INSERT INTO yVALUES ('It is "perfect".','\t');

INSERT INTO yVALUES ('',NULL);

COPY y TO stdout WITH CSV;

COPY y TO stdout WITH CSV QUOTE'''' DELIMITER'|';

COPY y TO stdout WITH CSV FORCE QUOTE col2 ESCAPE'\\';

DROPTABLE x;

DROPFUNCTION fn_x_before();

DROPFUNCTION fn_x_after();