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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: \copy command: how to define a tab character as the delimiter
Date: 2010-03-09 18:27:07
Message-ID: 25316.1268159227@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> The main reason I asked, was that the manual actually claims that '\t' can be used ("The following special backslash sequences are recognized by COPY FROM")

\t is recognized in the copy data, not in the command's parameters.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Fitzpatrick 2010-03-09 18:35:23 Re: Update view/table rule order of operations or race condition
Previous Message Joshua D. Drake 2010-03-09 18:21:23 PostgreSQL Conference East, Hotel Discount Deadline