Re: Importing into Postgres from a csv file - Mailing list pgsql-general

From John McKown
Subject Re: Importing into Postgres from a csv file
Date
Msg-id Pine.LNX.4.21.0008241240500.1830-100000@linux2.johnmckown.net
Whole thread Raw
In response to Re: Importing into Postgres from a csv file  ("Roderick A. Anderson" <raanders@altoplanos.net>)
List pgsql-general
On Thu, 24 Aug 2000, Roderick A. Anderson wrote:

> On Thu, 24 Aug 2000, John McKown wrote:
>
> > I think that you can do this using the COPY verb in psql.
> >
> > COPY table FROM file USING DELIMITERS ',';
>
> Be aware you will probably have to start psql as the postgres (superuser)
> to use the COPY command.
>
> But ... the \copy version is usable by normal users.

Why do you need to be the postgres superuser to do this this? I admin that
I have only used the COPY table FROM STDIN; version of the command. It
works under my "normal" id.

Just curious,
John


pgsql-general by date:

Previous
From: "Peter Mount"
Date:
Subject: Re: No Suitable Driver
Next
From: Stephan Szabo
Date:
Subject: Re: FW: Count & Distinct