Re: how to recognise databses

From: Mailing List <list(at)1006(dot)org>
To: Ashok Chauhan <ashok(at)kalculate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to recognise databses
Date: 2003-10-20 07:37:59
Message-ID: 1066635479.5961.38.camel@linuxbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> we have made 4 databases in postgresql, now we want to know how can be
> recognize these database files in /var/lib/pgsql/data/base.

Execute this query:

select datname, datid from pg_stat_database;

Bye, Chris.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ashok Chauhan 2003-10-20 07:38:24 how to recognise databses
Previous Message mathan 2003-10-20 05:06:55 Re: postgres installed via rpms -can't run postmaster or