Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: \copy command: how to define a tab character as the delimiter
Date
Msg-id 22140.1268155317@sss.pgh.pa.us
Whole thread Raw
In response to \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 
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.

            regards, tom lane

pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: DROP column: documentation unclear
Next
From: Bryan Montgomery
Date:
Subject: Re: Trying to get a C function built with MSVC