Joao Ferreira gmail wrote:
Hello all,
I need to print to a file a simple list of all the databases on my
postgresql.
I need to do this from a shell script to be executed without human
intervention
I guess something like:
su postgres -c 'psql ...whatever.... > /tmp/my_databases.txt'
but I don't know exactly to what extent I can format the output of this
in order to simplify the parser that will read that file.
any suggestions ?
thank you
joao
psql -tc 'select datname from pg_database' template1
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
