Dhimant Patel <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
