Thread: Size of database

Hello:

How can I check the size of the database? When I go to the directory of
$PGDATA/base, I found lots of sub-directories (their names are as numbers).
How can I identify which directory is representing the corresponding
database?

Thanks!
Carmen

_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

"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