Postgres Pro
Downloads
Home   >   mailing lists

Re: \copy command: how to define a tab character as the delimiter - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: \copy command: how to define a tab character as the delimiter
Date
Msg-id 4B9687C3.50406@iol.ie
Whole thread Raw
In response to Re: \copy command: how to define a tab character as the delimiter  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: \copy command: how to define a tab character as the delimiter  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: question on 8.4.2 build postgres C functions
Next
From: Dan Fitzpatrick
Date:
Subject: Re: Update view/table rule order of operations or race condition