How do I capture the output of conninfo into a variable in postgresql's psql? - Stack Overflow

admin管理员组

文章数量:1221386

I'm writing a psql sql script to generate an sql script. The way I do this, is by writing every ouputline to a temptable and later on \copy that to the output sql file.

I'd like to include the \conninfo output to the header of the file but I can't seem to capture its output into a variable.

What I tried :

\set conninfo \conninfo

\o tempfile.txt
\conninfo
\o
\set conninfo `cat tempfile.txt`

None seem to work, I assume \conninfo writes to STDERR.

Does anybody have a solution ?

I'm writing a psql sql script to generate an sql script. The way I do this, is by writing every ouputline to a temptable and later on \copy that to the output sql file.

I'd like to include the \conninfo output to the header of the file but I can't seem to capture its output into a variable.

What I tried :

\set conninfo \conninfo

\o tempfile.txt
\conninfo
\o
\set conninfo `cat tempfile.txt`

None seem to work, I assume \conninfo writes to STDERR.

Does anybody have a solution ?

• postgresql
• psql

Share Improve this question Follow asked Feb 7 at 19:50 Peter Van BiesenPeter Van Biesen 1111 silver badge22 bronze badges New contributor Peter Van Biesen is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

From here:

https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-VARIABLES

\set con_info 'Connected to ' :DBNAME  ' at '  :PORT ' as ' :USER

\echo :con_info
Connected to test at 5432 as postgres

This uses the built in variables provided in psql to build a connection description.

本文标签： How do I capture the output of conninfo into a variable in postgresql39s psqlStack Overflow