Problems with scripting postgreSQL commands

Question

Is there any possibility to dump the results of PostgreSQL commands directly on a txt/csv file ? i am talking about commands not queries, commands such as - SHOW ssl; - SHOW log_connections;

Thomas Berger · Accepted Answer · 2018-07-26 09:58:23Z

1

You can use the psql client for that.

\f ','
\a
\o <myoutputfile>
SHOW ssl;
\q

Or with command line options:

psql -t -A -F"," -c "SHOW ssl" > "<myoutputfile>"

answered Jul 26, 2018 at 9:58

Thomas Berger

1,87013 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rahmouni Abdelhak Over a year ago

The 1st method works fine .. but i like the 2nd one better to script using batch .. but i couldn't force the login/connection credentials into the script .. any ideas @Thomas ?

Thomas Berger Over a year ago

You can provide much of the information, including password, as environment variables to psql: postgresql.org/docs/current/static/libpq-envars.html

Collectives™ on Stack Overflow

Problems with scripting postgreSQL commands

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related