Re: Identifying databases.

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 the
numbers will correspond to the oid.

> This actually can also help M/s. Anagha Joshi to find out relevant database
> size and
> possibly take backup in tarred form.
>

guess i'd have to look at the specifics, but if she created her tar ball
on a live database then theres a good chance it wont work.

btw - just want to make a request to people to please not "hijack" other
peoples threads when posting to the list. This can happen if you hit
"reply to" on a message you don't intend to reply to, instead of create
a new email and addressing it properly. It messes up threading of
peoples requests for threaded email clients, newsgroup followers, and in
the archives, and it tends to reduce the chances of both the hijacker
and hijackee of getting a response.

Robert Treat