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