Postgres Pro
Downloads
Home   >   mailing lists

Re: how to recognise databses - Mailing list pgsql-admin

From Mailing List
Subject Re: how to recognise databses
Date
Msg-id 1066635479.5961.38.camel@linuxbox
Whole thread Raw
In response to how to recognise databses  (Ashok Chauhan <ashok@kalculate.com>)
List pgsql-admin
Tree view 
> 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.

pgsql-admin by date:

Previous
From: Ashok Chauhan
Date:
Subject: how to recognise databses
Next
From: Ashok Chauhan
Date:
Subject: help me