Re: COPY Command and a non superuser user?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Warren <warren(at)clarksnutrition(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY Command and a non superuser user?
Date: 2007-06-14 20:02:08
Message-ID: 46719EC0.30100@g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2007-06-14 20:06:43 Re: Function with COPY command?
Previous Message Tom Lane 2007-06-14 19:59:46 Re: Function with COPY command?