Horton

Re: [GENERAL] viewing dbs

Kevin Heflin <kheflin@shreve.net>

View thread View on postgr.es
From: Kevin Heflin <kheflin@shreve.net>
To: kaiq@realtyideas.com
Cc: "PGSQL-General (E-mail)" <pgsql-general@postgreSQL.org>
Date: 1999-12-07T21:42:09Z
Lists: pgsql-general 
On Tue, 7 Dec 1999 kaiq@realtyideas.com wrote:

> select * from pg_database order by datname;


thank you very much for that bit of info. Very helpful. I knew there had
to be something.


thanks again.



Kevin




> 
> 
> On Tue, 7 Dec 1999, Kevin Heflin wrote:
> 
> > 
> > I use  \l 
> > to view a list of all the DBs in use on our server.
> > I'm not sure what order these are in, but is there a way to view all the
> > DBs in alphabetical order ?
> > 
> > 
> > Kevin
> > 
> > --------------------------------------------------------------------
> > Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
> > VP/Production         | 333 Texas St #175    | FAX:318.221.6612
> > kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
> > --------------------------------------------------------------------
> > 
> > 
> > ************
> > 
> 

--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Production         | 333 Texas St #175    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------