I noticed that in PG 8.1 the docs for COPY TO say that you can use WITH
HEADER, but when I do that it throws an error saying that this works
only in CSV mode. Is this a bug or do I have something wrong with my syntax?
COPY mytable TO '/data/out.txt'
WITH HEADER DELIMITER '|' NULL '' ;