"yazicivo" <[EMAIL PROTECTED]> writes:
> The problem is, bcp.exe
> - Uses nothing to specify null fields, which is equivalent to
> COPY ... WITH NULL AS ''
> in PostgreSQL.
> - Uses \x00 character to specify empty strings.
Ugh. You're going to have to fix the null-char problem externally
--- perhaps run a Perl script over the dump before you import.
There's no way those triggers will work, quite aside from your
difficulties in auto-generating them, because \0 isn't valid in
PG text values.
regards, tom lane
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
