how to get binary data from sql query?

Question

I have a PostgreSQL table containing some binary data.

I need to get the content of "select content from repository where documentuniqueid='1.3.6.1.4.1.21367.2010.1.2.166.155015116013230039.13086'" as a binary feed.

Is there a way to do this?

Thank you.

I'm not sure how it works directly within psql, but most programming languages will let you get binary data from blobs. It depends on the programming language. Which one are you using? — Bruno
– Bruno, Commented Jun 21, 2011 at 19:07
mmm... the simplest? I use Java. Isn't there any other way except to program something? — code-gijoe
– code-gijoe, Commented Jun 21, 2011 at 19:09

Csuki · Accepted Answer · 2023-07-04 07:45:16Z

2

If you're using Java, you'll find some documentation about handling BLOBs via JDBC in the PostgreSQL JDBC driver documentation (e.g. via an InputStream).

You may also be interested in this question: Postgresql, JDBC, and streaming BLOBs

If you're not necessarily using Java, you may be interested in lo_export(), as @marto said.

edited Jul 4, 2023 at 7:45

Csuki

1,37611 silver badges22 bronze badges

answered Jun 21, 2011 at 19:24

Bruno

123k33 gold badges278 silver badges389 bronze badges

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

2 Comments

code-gijoe Over a year ago

ALTER TABLE repository ADD COLUMN "content" bytea; So stored as byte stream.

Bruno Over a year ago

As the documentation says, you should be able to extract the data using either ResultSet.getBytes(...) or ResultSet.getBinaryStream(...), depending on whether you want to read the result as a byte[] or an InputStream (however it was stored there in the first place doesn't really matter).

marto · Accepted Answer · 2011-06-21 19:13:56Z

1

Stored in a Blob I assume?

lo_export()

answered Jun 21, 2011 at 19:13

marto

4,53127 silver badges15 bronze badges

1 Comment

code-gijoe Over a year ago

ALTER TABLE repository ADD COLUMN "content" bytea;

Collectives™ on Stack Overflow

how to get binary data from sql query?

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related