About "ERROR: must be *superuser* to COPY to or from a file" - Mailing list pgsql-general

From Emi Lu
Subject About "ERROR: must be *superuser* to COPY to or from a file"
Date
Msg-id 430F78E0.9020206@cs.concordia.ca
Whole thread Raw
Responses Re: About "ERROR: must be *superuser* to COPY to or from a file"  (Douglas McNaught <doug@mcnaught.org>)
List pgsql-general
Greetings,

I met a question about Copy. I tried to run :
   copy test(studid) from '/myownDIR/a.txt';

But I got an error as the following:
ERROR:  must be *superuser* to COPY to or from a file

May I know is it possible that instead of supervuser, regular users are
able to use COPY as well?


Thanks a lot and Good weekend,
Emi



pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Altering functions cast
Next
From: Tom Lane
Date:
Subject: Re: PG 8.0 "CONNECT BY" patch