Problems with \copy and delimiters ','

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Problems with \copy and delimiters ','
Дата
Msg-id 400834B0.9010001@potentialtech.com
обсуждение исходный текст
Ответы Re: Problems with \copy and delimiters ','  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm having some problems using \copy

I have a directory full of test data that I want to be installed automatically
when "make database" is issued.  While the Makefile rules would seem simple, I'm
having some trouble.

I want to do this
\copy table_name from 'table_name.cdf' delimiters ',';

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

A similar command:
copy table_name from '/path/to/file/table_name.cdf' delimiters ',';
works fine, but this makes things complicated, as I don't know the path to the
files until it happens (who knows where the tarball will be unpacked, I want to
give a relative path, not an absolute).

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

Does the \copy command not support "delimiters"?  This is 7.4 on FreeBSD 5.1.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com


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

Предыдущее
От: "Rick Gigger"
Дата:
Сообщение: Re: embedded/"serverless" (Re: serverless postgresql)
Следующее
От: David Garamond
Дата:
Сообщение: Re: Creating GUID