Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query
Date
Msg-id 23179.1252592172@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query  ("Andrew Deryabin" <andrew@deryabin.com>)
List pgsql-bugs
Tree view 
"Andrew Deryabin" <andrew@deryabin.com> writes:
> [pgsql@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 lane

pgsql-bugs by date:

Previous
From: "Andrew Deryabin"
Date:
Subject: BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query
Next
From: "mahmoud badr"
Date:
Subject: BUG #5046: java developer