Re: COPY Command and a non superuser user? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: COPY Command and a non superuser user?
Date
Msg-id 46719EC0.30100@g2switchworks.com
Whole thread Raw
In response to COPY Command and a non superuser user?  (Warren <warren@clarksnutrition.com>)
List pgsql-general
Warren wrote:
> How do I get a non superuser user to be able to run the COPY command?
>
You can copy to / from the stdin.

non-superusers cannot run copy to / from a file, since the copy to /
from a file does so with the access authority of the postgres user and
could be used to do "bad things" TM

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function with COPY command?
Next
From: "Shoaib Mir"
Date:
Subject: Re: Function with COPY command?