Thread: 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
Attachment
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