Wiki / psql Commands / Output and formatting
\out
Arranges to save future query results to the file filename or pipe future results to the shell command command . If no argument is specified, the query output is reset to the standard output.
Reading PostgreSQL 18.6.
Description
Arranges to save future query results to the file filename or pipe future results to the shell command command . If no argument is specified, the query output is reset to the standard output.
- Client
- psql 18.6
- Case-sensitive spelling
- \out
Usage
\o or \out [ filename ] \o or \out [ | command ]Spellings in this manual definition
Manual definition
\oor\out [filename]\oor\out [ |command]-
Arranges to save future query results to the file
filenameor pipe future results to the shell commandcommand. If no argument is specified, the query output is reset to the standard output.If the argument begins with
|, then the entire remainder of the line is taken to be thecommandto execute, and neither variable interpolation nor backquote expansion are performed in it. The rest of the line is simply passed literally to the shell.“Query results” includes all tables, command responses, and notices obtained from the database server, as well as output of various backslash commands that query the database (such as
\d); but not error messages.Tip
To intersperse text output in between query results, use
\qecho.
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.