pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedWriting code to list Databases ?
2+ messages / 2 participants
[nested] [flat]
* Writing code to list Databases ?
@ 2003-08-24 01:55 Peter Moscatt <pgmoscatt@optushome.com.au>
2003-08-24 01:56 ` Re: Writing code to list Databases ? Joe Conway <mail@joeconway.com>
0 siblings, 1 reply; 2+ messages in thread
From: Peter Moscatt @ 2003-08-24 01:55 UTC (permalink / raw)
To: pgsql-interfaces
Are there routines that allow me to list databases within PostGres ?
Pete
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Writing code to list Databases ?
2003-08-24 01:55 Writing code to list Databases ? Peter Moscatt <pgmoscatt@optushome.com.au>
@ 2003-08-24 01:56 ` Joe Conway <mail@joeconway.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joe Conway @ 2003-08-24 01:56 UTC (permalink / raw)
To: pgmoscatt@optushome.com.au; +Cc: pgsql-interfaces
Peter Moscatt wrote:
> Are there routines that allow me to list databases within PostGres ?
>
From a shell prompt, use `psql -l`. The SQL command is:
select datname from pg_database;
HTH,
Joe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-24 01:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-24 01:55 Writing code to list Databases ? Peter Moscatt <pgmoscatt@optushome.com.au>
2003-08-24 01:56 ` Joe Conway <mail@joeconway.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox