select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.4 / 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 7.4 reached end of support in October 2010. See the current manual for supported releases.

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.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.