Re: Space for pg_dump

Rainer Bauer <usenet(at)munnin(dot)com> writes:
> Greg Smith wrote:
>> Since running an entire pgdump can take forever on a big database, what I
>> usually do here is start by running the disk usage query at
>> http://wiki.postgresql.org/wiki/Disk_Usage

> Interesting. However, the query gives an error if the table name contains
> upper case characters, like in my case "tblConnections":

> ERROR: relation "public.tblconnections" does not exist.

> Replacing all occurences of <relname> by <'"' || relname || '"'> fixes the
> error.

That still fails if the table name contains double quotes. A proper
solution is to use the table OID --- I've corrected the example.

regards, tom lane