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

[Thomas Kellerer]

Tom Lane wrote on 09.03.2010 18:21:

Thomas Kellerer<spam_ea...@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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general