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

From Cynthia Hombakazi Ngejane
Subject Syncing Data of data type BLOB into Postgres- Bytea
Date
Msg-id CANdCqGydDLciwZiagYMvWzPKjh=_gbYetVeEAs70ZWf36OcWDg@mail.gmail.com
Whole thread Raw
Responses Re: Syncing Data of data type BLOB into Postgres- Bytea  (John DeSoi <desoi@pgedit.com>)
List pgsql-general
Hello Everyone,

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.

Please Help...

CH Ngejane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_restore --clean failing due to dependancies
Next
From: Andreas Brandl
Date:
Subject: Change column type from int to bigint - quickest way