On 2/18/2016 4:44 PM, CS DBA wrote:
The system stores PDF's as large objects
in bytea columns.
Large Objects aka LO's and bytea columns are two completely different
things.
bytea columns are regular SQL database columns that contain a binary
byte array. large objects (LO) are a whole separate facility, where
each object is referenced by a unique OID, and the object is read and
written with the lo_XXX() functions in libpq, or equivalents in other
language specific bindings.
http://www.postgresql.org/docs/current/static/largeobjects.html
in a C program, an LO can be exported to a file via the API lo_export()
http://www.postgresql.org/docs/current/static/lo-interfaces.html#LO-EXPORT
Can anyone send me an example of
exporting from a bytea column to a PDF file?
I don't think you can get from a bytea field to a file without some
coding, as SQL scripting doesn't handle binary blobs very well.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
