Обсуждение: viewing dbs
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 --------------------------------------------------------------------
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 > -------------------------------------------------------------------- > > > ************ >
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 --------------------------------------------------------------------
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