1

Thank you for reading my question.

We are accessing a Postgres database through SOCI. The schema requires to have tables that contain BLOB fields. Based on PostgreSQL documentation, the ideal type to store a BLOB in a Postgres table is pg_largeobject.

PostgreSQL method of accessing the pg_largeobject involves dealing with oids. But I was unable to find any details on SOCI documentation regarding this. Have anyone tried this?

S-Man
  • 22,521
  • 7
  • 40
  • 63
Sampath
  • 1,144
  • 1
  • 21
  • 38
  • 2
    Interesting library. However [`soci/tests/postgresql/test-postgresql.cpp`](https://github.com/SOCI/soci/blob/master/tests/postgresql/test-postgresql.cpp), `TEST_CASE("PostgreSQL blob", "[postgresql][blob]")` is not what you searching for? – Abelisto Aug 26 '16 at 07:38
  • Thank you very much. They have a test which they use oid fields to store BLOBS. This is exactly I wanted to get things going. Thanks again. – Sampath Aug 26 '16 at 13:29

0 Answers0