Re: [BUGS] BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query

2009-09-10 Thread Tom Lane
"Andrew Deryabin" writes: > [pg...@localhost:site]=# COPY (SELECT 1) TO STDOUT \g filename.ext The way you're supposed to do that is with \copy. It might be more consistent to do it as above, but I'm not sure anyone will take the time to make it happen ... regards, tom la

[BUGS] BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query

2009-09-10 Thread Andrew Deryabin
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.