Dhimant Patel <drp4kri@xxxxxxxxx> writes: > I have created a database, which I plan to load with several tables. I am > trying to find the size of the databases and came > across pg_database_size(oid) function. Since it requires databse oid, I > thought there must be a view where you get it - then came across > "pg_database" table and still all in vain. The "pg_database" table lists all > databases in the server but won't provide me the oid > for pg_database_size(). What you lack is the knowledge that oid is a system column in these tables, meaning it isn't displayed by "SELECT * FROM ...". It's there though and you can select it explicitly: select oid from pg_database where datname = 'foo'; http://www.postgresql.org/docs/8.4/static/ddl-system-columns.html regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
