Re: run COPY as user other than postgres - Mailing list pgsql-general

From Kirk Wythers
Subject Re: run COPY as user other than postgres
Date
Msg-id 2743E23B-EC21-497C-BCAE-D6E3D8E9CBF6@umn.edu
Whole thread Raw
In response to Re: run COPY as user other than postgres  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
On Apr 24, 2013, at 6:14 AM, Bill Moran <wmoran@potentialtech.com> wrote:
>>>
>
> Write your own client that uses the copy interface to
> load a file from wherever and send it to the server.
>
> Or just use the one built in to psql, as Jasen suggested.
>

I am using "copy to" to write data from the db out to csv files. The psql suggestion of using \copy worked like a
charm. 





pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: DISTINCT ON changes sort order
Next
From: François Beausoleil
Date:
Subject: CLUSTER, REINDEX and VACUUM on batch ops