Re: Syncing Data of data type BLOB into Postgres- Bytea

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Cynthia Hombakazi Ngejane <hombakazi(dot)ngejane(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Syncing Data of data type BLOB into Postgres- Bytea
Date: 2016-11-16 01:55:40
Message-ID: B6D671F2-10DD-459C-9F34-EDAB4D563CA1@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Nov 10, 2016, at 12:55 AM, Cynthia Hombakazi Ngejane <hombakazi(dot)ngejane(at)gmail(dot)com> wrote:
>
> I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture on site (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.

It is going to be hard to help without seeing the exact code you are using to insert and the exact error message you are seeing.

John DeSoi, Ph.D.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2016-11-16 02:00:14 Re: Upgrade from 9.5.4 to 9.6.1
Previous Message Adrian Klaver 2016-11-16 01:43:04 Re: Upgrade from 9.5.4 to 9.6.1