Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 28 Sep 2007 14:40:03 -0500
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?
- Follow-Ups:
- Re: ERROR: must be superuser to COPY to or from a file
- From: Kamchybek Jusupov
- Re: ERROR: must be superuser to COPY to or from a file
- From: Sean Davis
- Re: ERROR: must be superuser to COPY to or from a file
- Prev by Date: Why is my view ddl being altered by postgres?
- Next by Date: Re: ERROR: must be superuser to COPY to or from a file
- Previous by thread: Why is my view ddl being altered by postgres?
- Next by thread: Re: ERROR: must be superuser to COPY to or from a file
- Indexes: