ERROR: must be superuser to COPY to or from a file

From: "Jorge Alberto" <csnmgeek(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: ERROR: must be superuser to COPY to or from a file
Date: 2007-09-28 19:40:03
Message-ID: 67a412e40709281240u1866cf02g901b2b77ee293f31@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello
I want to fill in a table from a file, but when I use the COPY command I get
the following error:

mydb=> COPY weather FROM '/home/fideito/weather.txt';
ERROR: must be superuser to COPY to or from a file
HINT: Anyone can COPY to stdout or from stdin. psql's \copy command also
works for anyone.

But, what can I do if I'm not root?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-09-28 19:58:03 Re: ERROR: must be superuser to COPY to or from a file
Previous Message Brent Friedman 2007-09-28 19:06:48 Why is my view ddl being altered by postgres?