Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: \copy command: how to define a tab character as the delimiter
Date
Msg-id hn60j7$4cn$1@dough.gmane.org
Whole thread Raw
In response to Re: \copy command: how to define a tab character as the delimiter  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: \copy command: how to define a tab character as the delimiter  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
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?


Thanks
Thomas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DROP column: documentation unclear
Next
From: Tom Lane
Date:
Subject: Re: question on 8.4.2 build postgres C functions