Wiki / psql Commands / Data transfer and large objects
\lo_import
Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example:
Reading PostgreSQL 18.6.
Description
Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example:
- Client
- psql 18.6
- Case-sensitive spelling
- \lo_import
Usage
\lo_import filename [ comment ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \lo_import | None listed in this signature |
Manual definition
\lo_importfilename[comment]-
Stores the file into a PostgreSQL large object. Optionally, it associates the given comment with the object. Example:
foo=>
\lo_import '/home/peter/pictures/photo.xcf' 'a picture of me'lo_import 152801The response indicates that the large object received object ID 152801, which can be used to access the newly-created large object in the future. For the sake of readability, it is recommended to always associate a human-readable comment with every object. Both OIDs and comments can be viewed with the
\lo_listcommand.Note that this command is subtly different from the server-side
lo_importbecause it acts as the local user on the local file system, rather than the server's user and file system.
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.