[Eug-lug] Translate file name to Postgres DB name

[Rob Hudson]

Is there a way, from within Postgresql, to view the filesize usage of
its databases and tables?  That might be the best approach and sounds
easier than looking at the raw data directory.

On Wed Jan 31, 2007 at 02:35:16PM -0800, larry price wrote:
> short answer: you can but it's ugly
> 
> longer answer:
> start looking at the pg_catalog.* relations (use \d from psql prompt)
> as I understand it the files under $PG_DATA/base/  are named after
> oid's for tables and relations, but there are a lot of subtleties, and
> the whole point of a DBMS is to manage that bookkeeping for you.