The following bug has been logged online:

Bug reference:      5048
Logged by:          Andrew Deryabin
Email address:      and...@deryabin.com
PostgreSQL version: 8.4
Operating system:   FreeBSD
Description:        psql: \g doesn't redirect COPY TO STDOUT, but redirects
next query
Details: 

[pg...@localhost:site]=# COPY (SELECT 1) TO STDOUT \g filename.ext
1
Time: 0.370 ms
[pg...@localhost:site]=# SELECT 2;
Time: 0.290 ms
[pg...@localhost:site]=# SELECT 3;
 ?column?
----------
        3
(1 row)

Time: 0.295 ms
^Z
$ cat filename.ext
 ?column?
----------
        2
(1 row)

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to