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