执行SQL取PostgreSQL数据库或表大小

在PostgreSQL8.1.3上可以work

 

1. 取数据库大小

SELECT pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize

 

2. 取表大小

SELECT pg_size_pretty(pg_total_relation_size('someschema.sometable')) As fulltblsize, pg_size_pretty(pg_relation_size('someschema.sometable')) As justthetblsize

 

原贴：

http://www.postgresonline.com/journal/index.php?/archives/110-Determining-size-of-database,-schema,-tables,-and-geometry.html