The following bug has been logged online:
Bug reference: 5048
Logged by: Andrew Deryabin
Email address: andrew(at)deryabin(dot)com
PostgreSQL version: 8.4
Operating system: FreeBSD
Description: psql: \g doesn't redirect COPY TO STDOUT, but redirects
next query
Details:
[pgsql(at)localhost:site]=# COPY (SELECT 1) TO STDOUT \g filename.ext
1
Time: 0.370 ms
[pgsql(at)localhost:site]=# SELECT 2;
Time: 0.290 ms
[pgsql(at)localhost:site]=# SELECT 3;
?column?
----------
3
(1 row)
Time: 0.295 ms
^Z
$ cat filename.ext
?column?
----------
2
(1 row)