Rainer Bauer <usenet@munnin.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
