Re: loading files into tables

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема Re: loading files into tables
Дата
Msg-id 20080204174245.09bb87a6@webthatworks.it
обсуждение исходный текст
Ответ на Re: loading files into tables  ("Pau Marc Munoz Torres" <paumarc@gmail.com>)
Список pgsql-general
On Mon, 4 Feb 2008 17:21:00 +0100
"Pau Marc Munoz Torres" <paumarc@gmail.com> wrote:

> Ok
>
>  I'm tryint to execute
>
>      copy local from "/path" with delimiter "\t";
>
> and I get the following errors
>
>   ERROR: must be superuser to COPY to or from a file.
>
>  Can I do something similar to it without being superuser?
>
>  for a Tab delimiter, should i use "\t" character?

The message should be longer and actually explain what to do.

you can \copy or copy from stdin.

You could find this helpful:

http://www.postgresql.org/docs/techdocs.15

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: [pgsql-advocacy] PostgreSQL Certification
Следующее
От: "Selena Deckelmann"
Дата:
Сообщение: Re: [pgsql-advocacy] PostgreSQL Certification