Postgres Pro
Downloads
Home   >   mailing lists

ERROR: must be superuser to COPY to or from a file - Mailing list pgsql-novice

From Jorge Alberto
Subject ERROR: must be superuser to COPY to or from a file
Date
Msg-id 67a412e40709281240u1866cf02g901b2b77ee293f31@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: must be superuser to COPY to or from a file  (Sean Davis <sdavis2@mail.nih.gov>)
Re: ERROR: must be superuser to COPY to or from a file  (Kamchybek Jusupov <kjusupov@gmail.com>)
List pgsql-novice
Tree view
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?



pgsql-novice by date:

Previous
From: Brent Friedman
Date:
Subject: Why is my view ddl being altered by postgres?
Next
From: Sean Davis
Date:
Subject: Re: ERROR: must be superuser to COPY to or from a file