Porting PostgreSQL - Invalid Input Syntax for type Bytea

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Invalid Input Syntax for type Bytea

Erick Bautista

2005-08-23, 7:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links