"yazicivo" <yazicivo(at)ttmail(dot)com> 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