Re: Syncing Data of data type BLOB into Postgres- Bytea - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Syncing Data of data type BLOB into Postgres- Bytea
Date
Msg-id 173521f7-11c5-4dc7-60ef-3383b9dd40f4@aklaver.com
Whole thread Raw
In response to Syncing Data of data type BLOB into Postgres- Bytea  (Cynthia Hombakazi Ngejane <hombakazi.ngejane@gmail.com>)
List pgsql-general
On 11/13/2016 11:40 PM, Cynthia Hombakazi Ngejane wrote:
> 9.3
> it just says syntax error near (
> I have a variable QByteArray that stores the fingerprint data, then:
> I am using QString Query = "insert into tableName(colName) values
> (:valName)";
> prepare the query;
> then query.bindValue;
>
> lastly query.exec();
>

On my last post I never did get to the point I was trying to make, that
this this may be a string escaping issue. To help with identifying the
problem it would be good to know the value of:

standard_conforming_strings

in postgresql.conf and whether it is commented out or not.



--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Syncing Data of data type BLOB into Postgres- Bytea
Next
From: Jerome Wagner
Date:
Subject: Re: Converting a TimestampTz into a C# DateTime