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
Hi,
Le vendredi 17 novembre 2006 21:46, Wm.A.Stafford a écrit :
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
On Fri, 2006-11-17 at 15:46 -0500, Wm.A.Stafford wrote:
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.
\x05, aka control-e, ctl-e, ^e, C-e, etc, is