4.6. Large Object Processing Commands

4.6. Large Object Processing Commands
Prev	Chapter 4. pgtcl Command Reference	Next

pg_lo_creat — Create a large object
pg_lo_open — Open a large object
pg_lo_close — Close a large object
pg_lo_read — Read from a large object
pg_lo_write — Write to a large object
pg_lo_lseek — Seek to a position of a large object
pg_lo_lseek64 — Seek to a position of a large object, using a 64-bit offset
pg_lo_tell — Return the current seek position of a large object
pg_lo_tell64 — Return the current seek position of a large object, using 64-bit offsets
pg_lo_truncate — Truncate a large object, changing its size
pg_lo_truncate64 — Truncate a large object, changing its size, using a 64-bit offset
pg_lo_unlink — Delete a large object
pg_lo_import — Import a large object from a file
pg_lo_export — Export a large object to a file

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.

Note

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”.

Prev	Up	Next
pg_notice_handler	Home	pg_lo_creat