Postgres Pro
Downloads
Home   >   mailing lists

Thread: viewing dbs

viewing dbs

From
Kevin Heflin
Date:
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
--------------------------------------------------------------------

Re: [GENERAL] viewing dbs

From
Date:
select * from pg_database order by datname;


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

Re: [GENERAL] viewing dbs

From
Kevin Heflin
Date:
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
--------------------------------------------------------------------

Re: [GENERAL] viewing dbs

From
Peter Eisentraut
Date:
select * from pg_database order by datname;

I'm not sure why it's not ordered. That could perhaps be fixed.

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

--
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden