Re: [ADMIN] Identifying databases.

2003-05-30 Thread Andrew Sullivan
On Thu, May 29, 2003 at 09:36:55AM +0530, rakesh wrote: > How can the numbers be resolved to names? contrib/oid2name A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]>

Re: [ADMIN] Identifying databases.

2003-05-30 Thread Robert Treat
On Thu, 2003-05-29 at 00:06, rakesh wrote: > Hello All, > > The /var/lib/pgsql/data/base directory has the databases listed in numeric > form. > Earlier it used to be proper names. > > How can the numbers be resolved to names? > The easiest way is to do select oid,* from pg_database, where t

[ADMIN] Identifying databases.

2003-05-29 Thread rakesh
Hello All, The /var/lib/pgsql/data/base directory has the databases listed in numeric form. Earlier it used to be proper names. How can the numbers be resolved to names? This actually can also help M/s. Anagha Joshi to find out relevant database size and possibly take backup in tarred form. re