pg_database_size(oid)

From: Dhimant Patel <drp4kri(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_database_size(oid)
Date: 2010-02-17 16:59:06
Message-ID: f3e51c11002170859p3e79f889xde35110123676942@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have just started with postgres and after going through manual nearly for
2 hours, I need help.

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().

I noticed this being true for almost all reference views. For example,
pg_tablespace lists the tablespaces but no tablespace oid.
Function pg_tablespace_databases (tablespace_oid) , needs tablespace_oid,
but where I could get it from?

Please help!

-Thanks,
DP.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-02-17 17:16:41 Re: pg_database_size(oid)
Previous Message Dimitri Fontaine 2010-02-17 15:15:30 Re: COPY FROM wish list