pg_database_size(oid)
От | Dhimant Patel |
---|---|
Тема | pg_database_size(oid) |
Дата | |
Msg-id | f3e51c11002170859p3e79f889xde35110123676942@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pg_database_size(oid)
Re: pg_database_size(oid) Re: pg_database_size(oid) |
Список | 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.
В списке pgsql-general по дате отправления: