Unsupported versions: 6.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the supported versions listed above instead.
Prev Chapter 45. pgtcl Next


The pg_lo* routines are interfaces to the Inversion Large Objects in Postgres. The functions are designed to mimic the analogous file system functions in the standard Unix file system interface.

Table 45-1. PGTCL Commands

Command Description
pg_connect opens a connection to the backend server
pg_disconnect closes a connection
pg_exec send a query to the backend
pg_select loop over the result of a select statement
pg_result manipulate the results of a query
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 a large object
pg_lo_write write a large object
pg_lo_lseek seek to a position on a large object
pg_lo_tell return the current seek position of a large object
pg_lo_unlink delete a large object
pg_lo_import import a Unix file into a large object
pg_lo_export export a large object into a Unix file

Some commands equivalent to libpq commands are provided for connection and query operations.

The pg_lo* routines should typically be used within a BEGIN/END transaction block because the file descriptor returned by pg_lo_open is only valid for the current transaction. pg_lo_import and pg_lo_export MUST be used in a BEGIN/END transaction block.

Prev Home Next
pgtcl Up Examples