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

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: \copy command: how to define a tab character as the delimiter
Date: 2010-03-09 17:39:15
Message-ID: 4B9687C3.50406@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/03/2010 17:30, Thomas Kellerer wrote:
> Tom Lane wrote on 09.03.2010 18:21:
>> Thomas Kellerer<spam_eater(at)gmx(dot)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(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Fitzpatrick 2010-03-09 17:42:26 Re: Update view/table rule order of operations or race condition
Previous Message Sergey Konoplev 2010-03-09 17:33:27 Re: Deleting Large Objects