September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 7.4 / 7.3 / 7.2 / 7.1
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 other supported versions listed above instead.

pg_lo_export

Name

pg_lo_export -- export a large object to a file

Synopsis

pg_lo_export conn loid filename

Description

pg_lo_export writes the specified large object into a file.

Arguments

conn

The handle of a connection to the database in which the large object exists.

loid

The OID of the large object.

filename

Specifies the file into which the data is to be exported.

Return Value

None

Notes

pg_lo_export must be called within a BEGIN/COMMIT transaction block.