Re: \copy command: how to define a tab character as the delimiter

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: \copy command: how to define a tab character as the delimiter
Дата
Msg-id 4B9687C3.50406@iol.ie
обсуждение исходный текст
Ответ на Re: \copy command: how to define a tab character as the delimiter  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: \copy command: how to define a tab character as the delimiter  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
Дерево обсуждения 
On 09/03/2010 17:30, Thomas Kellerer wrote:
> Tom Lane wrote on 09.03.2010 18:21:
>> Thomas Kellerer<spam_eater@gmx.net>  writes:
>>> \copy foo (foo, bar) from foobar.txt delimiter as '\t' csv header
>>
>>> So how can I specify a tab character if I also need to specify that
>>> my file has a header line?
>>
>> Type an actual tab.
>>
>
> Blush....
>
> That easy?

This is Postgres you're talking about - of course it's that easy! :-)

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: question on 8.4.2 build postgres C functions
Следующее
От: Dan Fitzpatrick
Дата:
Сообщение: Re: Update view/table rule order of operations or race condition