>
>
> You are not using psql. "\copy" is a psql command. I don't think it's
> supported by PgAdmin III, though I could be wrong.
>
>
Right, '\copy' is not supported in PgAdmin III.
--Raghav
On 11/08/2011 7:56 PM, Siva Palanisamy wrote:
> FYI, I am using PostgreSQL 8.1.4.
Argh, ogod why?!?!?!
That version is *totally* unsupported on Windows. Not only that, but
you're running an ancient point-release - you are missing *19* patch
releases worth of bug fixes. The latest point-releas
>
> COMMAND: copy (select * from employee) to 'C:/emp.csv'
> ERROR: could not open file "C:/emp.csv" for writing: Permission denied
> ** Error **
> ERROR: could not open file "C:/emp.csv" for writing: Permission denied
> SQL state: 42501
>
> COMMAND: \copy (select * from employee)
ounts of both Windows Login and PostgreSQL.
Thanks and Regards,
Siva.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Boszormenyi Zoltan
Sent: Thursday, August 11, 2011 5:11 PM
To: pgsql-general@postgresql.org
Subject: Re: [GEN
--
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Siva Palanisamy
> Sent: Thursday, August 11, 2011 4:48 PM
> To: Andreas Kretschmer; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Copy command to handle view for my export r
quot;select"
>
> Thanks and Regards,
> Siva.
>
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of Andreas Kretschmer
> Sent: Thursday, August 11, 2011 2:23 PM
> To: pgsql-general@postgr
@postgresql.org
Subject: Re: [GENERAL] Copy command to handle view for my export requirement
Hi Andreas,
I tried the command as below. It failed. Please correct me.
\copy (select * from view1) to '/sample.csv' delimiters ',' csv header;
ERROR: \copy: parse error at "se
@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andreas Kretschmer
Sent: Thursday, August 11, 2011 2:23 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Copy command to handle view for my export requirement
Siva Palanisamy wrote:
> Hi All,
>
>
>
>
Siva Palanisamy wrote:
> Hi All,
>
>
>
> I understand that copy and \copy commands in PostgreSQL work only for tables.
> I
> want it to export the data from varies tables. Instead, I can create a view
> for
> the list of tables. Can the copy or \copy commands be utilized to operate on
> vie
Hi All,
I understand that copy and \copy commands in PostgreSQL work only for tables. I
want it to export the data from varies tables. Instead, I can create a view for
the list of tables. Can the copy or \copy commands be utilized to operate on
views directly? Please let me know on this.
Thank
10 matches
Mail list logo
