Re: run COPY as user other than postgres

From: Kirk Wythers <wythe001(at)umn(dot)edu>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: run COPY as user other than postgres
Date: 2013-04-24 15:14:42
Message-ID: 2743E23B-EC21-497C-BCAE-D6E3D8E9CBF6@umn.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 24, 2013, at 6:14 AM, Bill Moran <wmoran(at)potentialtech(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message François Beausoleil 2013-04-24 15:49:58 CLUSTER, REINDEX and VACUUM on batch ops
Previous Message Kevin Grittner 2013-04-24 15:00:06 Re: DISTINCT ON changes sort order