creating tab delim file
Jay R. Ashworth
jra at baylink.com
Mon Dec 3 11:53:14 PST 2007
On Wed, Oct 24, 2007 at 08:56:33AM -0400, Kenneth Brody wrote:
> > The pipes AFAIK kinda how the default Oracle way of doing imports
> >
> > For example to load pipe delimited data into postgreSQL table
> > CUSTOMER2 we run
> > \COPY CUSTOMER2 FROM '/appl/fpmerge/cust2.pipe' WITH DELIMITER '|' NULL ''
>
> In which case, you would tell filePro to use a pipe by using a pipe:
>
> f=|
Which is unintuitive to people because it's a string (well, ok,
'character') literal, unquoted in a context in which people would
expect to want to quote it.
Cheers,
-- jra
--
Jay R. Ashworth Baylink jra at baylink.com
Designer The Things I Think RFC 2100
Ashworth & Associates http://baylink.pitas.com '87 e24
St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274
Witty slogan redacted until AMPTP stop screwing WGA
More information about the Filepro-list
mailing list