Re: run COPY as user other than postgres

Поиск
Список
Период
Сортировка
От Kirk Wythers
Тема Re: run COPY as user other than postgres
Дата
Msg-id 2743E23B-EC21-497C-BCAE-D6E3D8E9CBF6@umn.edu
обсуждение исходный текст
Ответ на Re: run COPY as user other than postgres  (Bill Moran <wmoran@potentialtech.com>)
Список 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 по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: DISTINCT ON changes sort order
Следующее
От: François Beausoleil
Дата:
Сообщение: CLUSTER, REINDEX and VACUUM on batch ops