FAQ
Good Evening!

Our team is currently porting from Oracle to PostGreSQL.
For BLOBs in Oracle we used bytea datatype in PostGreSQL.
Whenever we insert a binary data in the DB, we get 'Invalid Input
Syntax for type Bytea'. I understand that we need to use
PQescapeBytea before putting the binary string in the SQL statement,
however, the same error appears even if we use it.

Can somebody give us some advise on how to properly insert Bytea data
in PostGreSQL.

By the way, we are using ECPG.

Thank you!

--
Erick

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedAug 23, '05 at 11:18a
activeAug 23, '05 at 11:18a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Erick Bautista: 1 post

People

Translate

site design / logo © 2022 Grokbase