Rainer Bauer <usenet@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
