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