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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: \copy command: how to define a tab character as the delimiter
Date: 2010-03-09 17:30:16
Message-ID: hn60j7$4cn$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-09 17:32:58 Re: question on 8.4.2 build postgres C functions
Previous Message Tom Lane 2010-03-09 17:28:03 Re: DROP column: documentation unclear