Re: Importing into Postgres from a csv file

Поиск
Список
Период
Сортировка
От John McKown
Тема Re: Importing into Postgres from a csv file
Дата
Msg-id Pine.LNX.4.21.0008241240500.1830-100000@linux2.johnmckown.net
обсуждение исходный текст
Ответ на Re: Importing into Postgres from a csv file  ("Roderick A. Anderson" <raanders@altoplanos.net>)
Список 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 по дате отправления:

Предыдущее
От: "Peter Mount"
Дата:
Сообщение: Re: No Suitable Driver
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: FW: Count & Distinct