Wiki / psql Commands / Data transfer and large objects
\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…
Reading PostgreSQL 18.6.
Description
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.
- Client
- psql 18.6
- Case-sensitive spelling
- \lo_export
Usage
\lo_export loid filenameSpellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \lo_export | None listed in this signature |
Manual definition
\lo_exportloidfilename-
Reads the large object with OID
loidfrom the database and writes it tofilename. Note that this is subtly different from the server functionlo_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_listto find out the large object's OID.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 17 → 18: unchanged.
Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.