We are having trouble coming up with a column separator for the Oracle
data that is being imported into our PostgreSQL DB. We are using
Fastreader to dump Oracle tables. We then use PostgreSQL copy to load
the table data into PostgreSQL. Unfortunately, some of the Oracle data
contains every ASCII printable character so we have to dump it with a
non-printing character as the column separator We can not figure out
how to specify a non-printing character for the delimiter in the
PostgreSQL copy command. If we use '\x05' as suggested by the
Fastreader User guide. PostgreSQL complains "ERROR: COPY delimiter
must be a single character".
Any help or suggestions would be appreciated.
-=bill stafford