How to insert (array) data into a PostgreSQL bytea column?

Question

How can I store the following data structure:

byte[] number = new byte[1000];

in bytea column in PostgreSQL with

INSERT INTO blobT command?

 CREATE TABLE blobT (
    blob      bytea
 );

What is the equivalence of bytea in MySQL and Microsoft SQL?

you can use blob in mysql.

chetan
– chetan

2013-07-04 11:18:13 +00:00
Commented Jul 4, 2013 at 11:18 — chetan
– chetan, Commented Jul 4, 2013 at 11:18

chetan · Accepted Answer · 2013-07-04 11:20:27Z

1

For MySql you can do

 CREATE TABLE blobT (
    bytea blob;     
 );


String query = "INSERT INTO blobT (bytea) VALUES (?)"; 
PreparedStatement pstmt = conn.prepareStatement(query);
pstmt.setBytes(1, bytea);
pstmt.execute();

answered Jul 4, 2013 at 11:20

chetan

2,9161 gold badge16 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

luksmir Over a year ago

How would you store bytea in Java?

Chris Travers Over a year ago

luksmir, I think bytea is escaped by the jdbc driver, so you should just be able to do a standard parameterized query, with the appropriate variable binding.

Collectives™ on Stack Overflow

How to insert (array) data into a PostgreSQL bytea column?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related