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