The commands in this section are used to create and work with PostgreSQL Large Objects. For more information about Large Objects, refer to the PostgreSQL reference manual, Client Interfaces, Large Objects chapter.
The Large Object commands must be used within a transaction block, beginning with BEGIN and ending with COMMIT or ROLLBACK. This is because the large object file descriptors (returned by pg_lo_open) are only valid for the current transaction.
Examples of Large Object commands can be found in Section 5.5, “Example - Large Objects - Picture Viewer, Part 1 - Store Pictures” and Section 5.6, “Example - Large Objects - Picture Viewer, Part 2 - View Pictures”.