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

[Thomas Kellerer <spam_eater@xxxxxxx>]

Tom Lane wrote on 09.03.2010 18:21:
> Thomas Kellerer<spam_eater@xxxxxxx>  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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general