Postgres Pro
Downloads
Home   >   mailing lists

Re: Size of database - Mailing list pgsql-general

From Tom Lane
Subject Re: Size of database
Date
Msg-id 26817.1032016326@sss.pgh.pa.us
Whole thread Raw
In response to Size of database  ("Carmen Wai" <wai_carmen@hotmail.com>)
List pgsql-general
Tree view 
"Carmen Wai" <wai_carmen@hotmail.com> writes:
> How can I identify which directory is representing the corresponding
> database?

"SELECT oid, datname FROM pg_database" will tell you.

See also the contrib/oid2name utility.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: explain analyze
Next
From: Tom Lane
Date:
Subject: Re: Can't run configure