KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'd like to insert some binary data into a BYTEA column, but I find the Doxygen output is lacking in details, and http://pqxx.org/ has been down for the past few days. How would I go about inserting the contents of somefile.bin into a table with a BYTEA column? What I have is along these lines: pqxx::work work( conn ); work.exec( "CREATE TABLE test ( name varchar(20), data BYTEA )" ); work.exec( "INSERT INTO test( name, data ) VALUES ( 'foo', <insert filename.bin here> )" ); work.commit(); If it makes a difference, I'd like to use the new hex format for BYTEA available in PostgreSQL 9.1.
Tags (comma-separated)
Save Edits
Cancel