creating tab delim file

[Walter Vaughan]

scooter6 at gmail.com wrote:

> FWIW - I did look at the help in processing for the proper way to create 
> what I wanted but the
> help for export is pretty limited in that it doesn't tell you much other 
> than how to use a comma as a delimiter -- what if you wanted to use a 
> pipe or some other character (which oddly enough I have gotten requests 
> for from other databases I work with, etc)
> Thanks again

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 ''