Re: Re: binary data - Mailing list pgsql-sql

From Hugh Mandeville
Subject Re: Re: binary data
Date
Msg-id 9gubbo$s6b$1@news.tht.net
Whole thread Raw
In response to Re: Re: binary data  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-sql
this works
"Alex Pilosov" <alex@pilosoft.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)




pgsql-sql by date:

Previous
From: "Alain Lavigne"
Date:
Subject: Re: Changing PL/pgSQL triggers
Next
From: "Wei Weng"
Date:
Subject: Problem with installing Postgresql 7.1.1