I'm confused. I have a bytea column that should be binary format (right?), yet PQfformat() says it is NOT binary (I did an insert as such: INSERT INTO tablename values (..., '\\001\\002\\000'); ). I also tried: INSERT INTO tablename values (..., '\\001\\002\\000'::bytea); .

Furthermore, my client code receives via PQgetvalue() a backslashed octet string which needs to be converted back into binary data via PQunescapeBytea() to get the binary contents, yet the documentation under PQunescapeBytea() (section 27.3.2) says its not needed when receiving binary data (implying there is a way to get binary data). How do I get/request binary data instead of text strings. My client code is connecting via TCP/IP if that makes a difference. I also noted in the documentation some sample client code that converted an int4 column to binary via: ntohl() also implying it was in binary format to begin with.

What's the secret? I would love to deal directly with binary data to avoid repetitious conversions to/from strings.

Thanks in advance for any advise!

--David Kitzinger


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

David Kitzinger ARA/SWD <David.Kitzinger (AT) ara (DOT) com> writes:
The column datatype has nothing to do with whether the data is presented
in binary or textual format. The way you determine that is by making a
query in the right way. See for instance the resultFormat parameter of
PQexecParams.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

You can do this with FETCH. Look it up in the docs for the full picture.

Marc

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend