inside psql turn \o file
then \l
2008/10/9 Jeff Ross <jross@wykids.org>:
> 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
>