Thread

1. viewing dbs

   Kevin Heflin <kheflin@shreve.net> — 1999-12-07T21:16:45Z

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

2. Re: [GENERAL] viewing dbs

   Kevin Heflin <kheflin@shreve.net> — 1999-12-07T21:42:09Z

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

3. Re: [GENERAL] viewing dbs

   Peter Eisentraut <e99re41@docs.uu.se> — 1999-12-07T21:50:29Z

   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
   
   
   

4. Re: [GENERAL] viewing dbs

   kaiq@realtyideas.com — 1999-12-07T22:32:02Z

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