On Fri, Jul 27, 2012 at 12:06 PM, Tom Lane wrote:
> Ryan Kelly writes:
>> I recently switched from OSX to Linux and \copy in psql no longer
>> accepts multi-line queries. For instance:
>
>> \copy (
>> select
>> *
>> from
>> pg_settings
>> ) to '/tmp/settings.csv' with csv
Ryan Kelly writes:
> I recently switched from OSX to Linux and \copy in psql no longer
> accepts multi-line queries. For instance:
> \copy (
> select
> *
> from
> pg_settings
> ) to '/tmp/settings.csv' with csv header
> This works fine on OSX. On Linux I get:
> \copy: par
On Fri, Jul 27, 2012 at 02:06:01PM +, Mark Morgan Lloyd wrote:
> Craig Ringer wrote:
> >On 07/27/2012 09:28 PM, Ryan Kelly wrote:
> >>I recently switched from OSX to Linux and \copy in psql no longer
> >>accepts multi-line queries. For instance:
> >>
> >>\copy (
> >> select
> >> *
>
On Fri, Jul 27, 2012 at 09:49:06PM +0800, Craig Ringer wrote:
> On 07/27/2012 09:28 PM, Ryan Kelly wrote:
> >I recently switched from OSX to Linux and \copy in psql no longer
> >accepts multi-line queries. For instance:
> >
> >\copy (
> > select
> > *
> > from
> > pg_setting
Craig Ringer wrote:
On 07/27/2012 09:28 PM, Ryan Kelly wrote:
I recently switched from OSX to Linux and \copy in psql no longer
accepts multi-line queries. For instance:
\copy (
select
*
from
pg_settings
) to '/tmp/settings.csv' with csv header
This works fine on OS
On 07/27/2012 09:28 PM, Ryan Kelly wrote:
I recently switched from OSX to Linux and \copy in psql no longer
accepts multi-line queries. For instance:
\copy (
select
*
from
pg_settings
) to '/tmp/settings.csv' with csv header
This works fine on OSX. On Linux I get:
\c
I recently switched from OSX to Linux and \copy in psql no longer
accepts multi-line queries. For instance:
\copy (
select
*
from
pg_settings
) to '/tmp/settings.csv' with csv header
This works fine on OSX. On Linux I get:
\copy: parse error at end of line
Am I missing so