\lo_export

Reads the large object with OID loid from the database and writes it to filename . Note that this is subtly different from the server function lo_export , which acts with the permissions of the user that the database server runs as and on the server's file system.

Reading PG 18·Select a recorded version

10 11 12 13 14 15 16 17 18 19 20

Client: psql 18.7
Case-sensitive spelling: \lo_export
command: \lo_export
manual path: app-psql.html#APP-PSQL-META-COMMAND-LO-EXPORT
modifiers: Unknown
signature: \lo_export loid filename
spellings: \lo_export

Definition PG 18

\lo_export loid filename: Reads the large object with OID loid from the database and writes it to filename. Note that this is subtly different from the server function lo_export, which acts with the permissions of the user that the database server runs as and on the server's file system.
Tip
Use \lo_list to find out the large object's OID.

Exact case-sensitive spellings

\lo_export

Spellings in this manual definition

Command	Documented suffix modifiers
\lo_export	None listed in this signature

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915

Text language: en · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915