this works
"Alex Pilosov" <alex(at)pilosoft(dot)com> wrote in message
>> what is the correct way to escape 0? \000 doesn't work for me.
>The correct way is \\\\000 (yes really).
>
>If you are using DBD::Pg after 0.98, it will happen for you automatically
>if you bind the variable as SQL_BINARY.
>> i also tried doing an insert and using quote() with perl (DBD::Pg v1.0)
>You must use $dbh->quote($bindata,DBI::SQL_BINARY) (and DBD::Pg after 1.0)