Re: [GENERAL] Loading a database, why do I need superuser? - Mailing list pgsql-general

From Simon Drabble
Subject Re: [GENERAL] Loading a database, why do I need superuser?
Date
Msg-id Pine.LNX.3.95.981120091155.8389B-100000@fiddletrudge.dyn.ml.org
Whole thread Raw
In response to Loading a database, why do I need superuser?  ("Gilley, Charles H." <Charles.Gilley@glenayre.com>)
List 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@syspac.com
   http://fiddletrudge.dyn.ml.org/KAP2/login.html
   http://fiddletrudge.dyn.ml.org/LizardCam/LizCam.html


pgsql-general by date:

Previous
From: Oleg Broytmann
Date:
Subject: Date/time problem
Next
From: Rob Cleveland
Date:
Subject: Monetary, Float Types