From: | Simon Drabble <simon(at)fiddletrudge(dot)dyn(dot)ml(dot)org> |
---|---|
To: | "Gilley, Charles H(dot)" <Charles(dot)Gilley(at)glenayre(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Loading a database, why do I need superuser? |
Date: | 1998-11-20 14:14:14 |
Message-ID: | Pine.LNX.3.95.981120091155.8389B-100000@fiddletrudge.dyn.ml.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 20 Nov 1998, Gilley, Charles H. wrote:
> I'm in the process of loading a database on a virtual server.
> Because I do not have root privileges (technically it is a shared machine),
> I am encountering all sorts of hiccups. Trying the copy command to
> load the database with comma delimited data, I encounter this complaint:
>
> ERROR: You must have Postgres superuser privilege to do a COPY
> directly to or from a file. Anyone can COPY to stdout or from stdin
>
> There is NO mention of this in the man page or documentation that I have
> perused. Perhaps I have a privilege problem?
>
> Charles Gilley
>
In psql you can use the \copy command to perform the same function:
\copy <table> to|from <file>
Any user can do this.
Simon.
--
To really understand a man, you must first walk a mile in his shoes. Then,
not only will you have his shoes, you'll be a mile away.
Simon Drabble madlather(at)syspac(dot)com
http://fiddletrudge.dyn.ml.org/KAP2/login.html
http://fiddletrudge.dyn.ml.org/LizardCam/LizCam.html
From | Date | Subject | |
---|---|---|---|
Next Message | Evan Howarth | 1998-11-20 14:47:00 | [GENERAL] Loading a database, why do I need superuser? |
Previous Message | Gilley, Charles H. | 1998-11-20 13:59:17 | Loading a database, why do I need superuser? |