Wiki / psql Commands / Scripting and assistance
\echo
Prints the evaluated arguments to standard output, separated by spaces and followed by a newline. This can be useful to intersperse information in the output of scripts. For example:
Reading PostgreSQL 18.6.
Description
Prints the evaluated arguments to standard output, separated by spaces and followed by a newline. This can be useful to intersperse information in the output of scripts. For example:
- Client
- psql 18.6
- Case-sensitive spelling
- \echo
Usage
\echo text [ ... ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \echo | None listed in this signature |
Manual definition
\echotext[ ... ]-
Prints the evaluated arguments to standard output, separated by spaces and followed by a newline. This can be useful to intersperse information in the output of scripts. For example:
=>
\echo `date`Tue Oct 26 21:40:57 CEST 1999If the first argument is an unquoted
-nthe trailing newline is not written (nor is the first argument).Tip
If you use the
\ocommand to redirect your query output you might wish to use\qechoinstead of this command. See also\warn.
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 12 → 13: changed.
--- PostgreSQL 12
+++ PostgreSQL 13
@@ -1,5 +1,5 @@
{
- "definition": "Prints the arguments to the standard output, separated by one space and followed by a newline. This can be useful to intersperse information in the output of scripts. For example: => \\echo `date` Tue Oct 26 21:40:57 CEST 1999 If the first argument is an unquoted -n the trailing newline is not written. Tip If you use the \\o command to redirect your query output you might wish to use \\qecho instead of this command.",
+ "definition": "Prints the evaluated arguments to standard output, separated by spaces and followed by a newline. This can be useful to intersperse information in the output of scripts. For example: => \\echo `date` Tue Oct 26 21:40:57 CEST 1999 If the first argument is an unquoted -n the trailing newline is not written (nor is the first argument). Tip If you use the \\o command to redirect your query output you might wish to use \\qecho instead of this command. See also \\warn .",
"modifiers": [],
"signature": "\\echo text [ ... ]",
"spellings": [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.