Quick Links

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

Re: \copy command: how to define a tab character as the delimiter at 2010-03-09 17:21:57 from Tom Lane

Responses

Re: \copy command: how to define a tab character as the delimiter at 2010-03-09 17:39:15 from Raymond O'Donnell

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