Re: selective export for subsequent import (COPY) - Mailing list pgsql-general

From Tom Lane
Subject Re: selective export for subsequent import (COPY)
Date
Msg-id 14905.1177040153@sss.pgh.pa.us
Whole thread Raw
In response to Re: selective export for subsequent import (COPY)  (chrisj <chrisj.wood@sympatico.ca>)
Responses Re: selective export for subsequent import (COPY)  (chrisj <chrisj.wood@sympatico.ca>)
Re: selective export for subsequent import (COPY)  (Andrew Kroeger <andrew@sprocks.gotdns.com>)
List pgsql-general
chrisj <chrisj.wood@sympatico.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

pgsql-general by date:

Previous
From: chrisj
Date:
Subject: Re: selective export for subsequent import (COPY)
Next
From: Tom Lane
Date:
Subject: Re: binding 64-bit integer