Re: list of databases in C ? libpq ?

On 5/7/2010 1:48 PM, Alex Hunsaker wrote:
> On Fri, May 7, 2010 at 11:18, Joao Ferreira gmail
> <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> wrote:
>> Hello all,
>>
>> I need to write an application in C to read the list of databases
>> currently in the server. very much like a "psql -l"...
>
The first example in the online docs does exactly that...
http://www.postgresql.org/docs/8.1/static/libpq-example.html

$ cc -I /usr/include/postgresql-8.4/ -lpq libpq.c -o libpqex

$ ./libpqex dbname=test
datname datdba encoding datcollate datctype datistemplate datallowconn
datconnlimit datlastsysoid datfrozenxid dattablespace datconfig datacl

template1 10 6 en_US.UTF-8 en_US.UTF-8 t t -1
11563 648 1663 {=c/postgres,postgres=CTc/postgres}
template0 10 6 en_US.UTF-8 en_US.UTF-8 t f -1
11563 648 1663 {=c/postgres,postgres=CTc/postgres}
postgres 10 6 en_US.UTF-8 en_US.UTF-8 f t -1
11563 648 1663
test 16384 6 en_US.UTF-8 en_US.UTF-8 f t -1
11563 648 1663
sigcap 16438 0 en_US.UTF-8 en_US.UTF-8 f t -1
11563 648 1663