Re: Problems with \copy and delimiters ','

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with \copy and delimiters ','
Дата
Msg-id 6086.1074282717@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problems with \copy and delimiters ','  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: Problems with \copy and delimiters ','  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
Bill Moran <wmoran@potentialtech.com> writes:
> I want to do this
> \copy table_name from 'table_name.cdf' delimiters ',';

> But I get:
> \copy: parse error at "delimiters"

Looking at the psql code, it evidently wants "with delimiter" ...

regression=# \copy table_name from 'table_name.cdf' with delimiter ','
table_name.cdf: No such file or directory

> The documentation I've found on \copy says to see the docs on copy ;)

It's *supposed* to match the backend syntax, but seems a few bricks
shy of a load at the moment.  Anyone feel like fixing it?  See
parse_slash_copy() in src/bin/psql/copy.c.

            regards, tom lane

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

Предыдущее
От: merlyn@stonehenge.com (Randal L. Schwartz)
Дата:
Сообщение: Re: Newbie to Postgres - Urgent query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: plpythonu AKA am I crazy? or....