databases list to file - Mailing list pgsql-general

From Joao Ferreira gmail
Subject databases list to file
Date
Msg-id 1223561638.6634.26.camel@jmf-ubuntu
Whole thread Raw
Responses Re: databases list to file
Re: databases list to file
List pgsql-general
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



pgsql-general by date:

Previous
From: "c k"
Date:
Subject: logging SQL statements
Next
From: "A. Kretschmer"
Date:
Subject: Re: databases list to file