Re: selective export for subsequent import (COPY)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chrisj <chrisj(dot)wood(at)sympatico(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: selective export for subsequent import (COPY)
Date: 2007-04-20 03:35:53
Message-ID: 14905.1177040153@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

chrisj <chrisj(dot)wood(at)sympatico(dot)ca> writes:
> This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
> not seem to work, any ideas??

I don't think there's any provision for backslash-notation in that
switch; you'd need to type an actual tab character there. Depending on
what shell you use, that might be a bit difficult on an interactive
shell command line, but it should be simple enough to insert one in a
script file.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-04-20 03:41:22 Re: binding 64-bit integer
Previous Message chrisj 2007-04-20 03:06:24 Re: selective export for subsequent import (COPY)