Re: [GENERAL] viewing dbs

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
--------------------------------------------------------------------