how to read data stored in blobs

Question

my application datbase in postgressql and from the document i understand that it store few data in a blob and from the table i can only get the oid of it.

is there any possibility to read the content from these blobs? if yes, could someone share the knowhow?

In most of the cases bytea is the better choice to store blobs. — user330315
– user330315, Commented Oct 20, 2015 at 10:10

Daniel Vérité · Accepted Answer · 2015-10-20 09:18:04Z

1

From the OID, a file with the contents of the large object can be exported.

Either client-side (psql):

  \lo_export oid-to-export /path/to/a/file

Or server-side in SQL (creates the file on the server, beware that postgres must have the permission to write into the destination directory).

   SELECT lo_export(oid-to-export, '/path/to/a/file');

answered Oct 20, 2015 at 9:18

Daniel Vérité

62.3k16 gold badges134 silver badges160 bronze badges

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

Collectives™ on Stack Overflow

how to read data stored in blobs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related