On 11/13/2016 11:40 PM, Cynthia Hombakazi Ngejane wrote: Please reply to list also. Ccing list.
9.3 it just says syntax error near (
Can you show the actual complete error?
I have a variable QByteArray that stores the fingerprint data, then: I am using QString Query = "insert into tableName(colName) values (:valName)";
What is the actual value of :valName? In other words is it the raw value or has it been escaped per here: https://www.postgresql.org/docs/9.3/static/datatype-binary.html
prepare the query; then query.bindValue; lastly query.exec(); On 10 November 2016 at 16:31, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote: On 11/09/2016 11:35 PM, Cynthia Hombakazi Ngejane wrote: Hello, I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture onsite (i.e offline) and my column is of type BLOB. Now I want to sync these templates into Postgres (to the server), so I created a column of type bytea but Postgres is refusing to take BLOB it says there was a syntax error. I am using Qt c++ 5.7 application to do the syncing. What version of Postgres? What is the syntax error? What is the code you are using to insert/update the data into Postgres? Please Help... CH Ngejane -- Adrian Klaver adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
