Обсуждение: Displaying database names from within application

I'm writing an application program which uses Postgresql
functionality via calls to the library libpq.

One of the things I'd like to do is present the user with a list of
possible database names to choose from, nicely formatted from within
a GUI, but I can't seem to find a way to access the database names
through system calls.

(Of course, I could make a system call, asking Unix to interpret the
string "psql -l", but I'd like to thing there is a more direct route
available to me, performing the same call to the Postgresql backend
that the command "psql -l" must do itself.)

I see in the Developer's Guide that there are catalogs with this
information, but I don't know how to query the catalogs.

Can someone help?

Thanks!

     -- Bill

select datname from pg_database;

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of William C Brennan
Sent: Friday, February 15, 2002 8:58 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Displaying database names from within application


I'm writing an application program which uses Postgresql
functionality via calls to the library libpq.

One of the things I'd like to do is present the user with a list of
possible database names to choose from, nicely formatted from within
a GUI, but I can't seem to find a way to access the database names
through system calls.

(Of course, I could make a system call, asking Unix to interpret the
string "psql -l", but I'd like to thing there is a more direct route
available to me, performing the same call to the Postgresql backend
that the command "psql -l" must do itself.)

I see in the Developer's Guide that there are catalogs with this
information, but I don't know how to query the catalogs.

Can someone help?

Thanks!

     -- Bill

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

William  C Brennan <brennan@netaxs.com> writes:
> (Of course, I could make a system call, asking Unix to interpret the
> string "psql -l", but I'd like to thing there is a more direct route
> available to me, performing the same call to the Postgresql backend
> that the command "psql -l" must do itself.)

Try "psql -E -l" to see the query psql generates for this purpose;
or to see any other query psql generates on its own.

            regards, tom lane