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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Deryabin" <andrew(at)deryabin(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query
Date: 2009-09-10 14:16:12
Message-ID: 23179.1252592172@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Andrew Deryabin" <andrew(at)deryabin(dot)com> writes:
> [pgsql(at)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-09-11 19:17:55 Re: need higher extra_float_digits value (3)
Previous Message Andrew Deryabin 2009-09-10 14:04:16 BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query