About "ERROR: must be *superuser* to COPY to or from a file"

From: Emi Lu <emilu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: About "ERROR: must be *superuser* to COPY to or from a file"
Date: 2005-08-26 20:17:36
Message-ID: 430F78E0.9020206@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-26 20:25:22 Re: PQConnectdb SSL (sslmode): Is this a bug
Previous Message Tom Lane 2005-08-26 20:16:13 Re: PG 8.0 "CONNECT BY" patch