Please guide me to store LOB-image or PDF in Postgresql and let me know what is the impact of storing these types of objects on Postgresql database.

Any help will be appreciated.


BYTEA is a good choice here.

The BYTEA data type allows storage of binary strings.

It stores a LOB within the table, respectively using TOAST. It is thus limited to 1 GB The storage is octal and allows non printable characters (in contrast to character strings which don't). The input/output format is HEX (as of PostgreSQL 9.0). Notes:

BYTEA comes close to the SQL standard binary string type 'BLOB'. The functions and operators provided by BYTEA are mostly the same, while HEX input format of BYTEA is different. BYTEA is slower for lengths >20 MB than the LO facility (it has no random accees).

More details can be found here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.