Re: A better COPY? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: A better COPY?
Date
Msg-id C96623CF-89CF-4CA3-96D8-4B67EE11B197@gmail.com
Whole thread Raw
In response to A better COPY?  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
On 26 Feb 2012, at 23:54, Tim Uckun wrote:

> The main reason I am not using COPY right now is because postgres will
> not allow unprivileged users to issue the COPY from FILENAME.  The
> only way I could get around this would be to shell out psql or
> something but I dont really want to do that.

Use COPY from STDIN and supply the contents of the file after that.

Alban Hertroys

--
The scale of a problem often equals the size of an ego.



pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: A better COPY?
Next
From: Dmytrii Nagirniak
Date:
Subject: Re: Optimise PostgreSQL for fast testing