<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Machiel Richards pisze:
<blockquote cite="mid:00b001caca68$74335090$5c99f1b0$(at)co(dot)za" type="cite">
<div class="Section1"><br>
<p class="MsoNormal"> Due to security restrictions I
am not yet
able to use pgadmin / pgphpadmin and need to manually calculate this
using ‘SELECT
pg_size_pretty(pg_database_size(''));’<o:p></o:p></p>
<p class="MsoNormal"><o:p></o:p> Is there a way of
running this in a script
for each database in the instance without having to manually type in
each
database name?<o:p></o:p></p>
</div>
</blockquote>
<small><font face="Courier New, Courier, monospace">select
pg_size_pretty(pg_database_size(datname)), datname from
pg_catalog.pg_database ;</font><br>
</small>
</body>
</html>