Hi ,
I am executing below query to get top 10 biggest size table but getting
error
SELECT table_name,pg_relation_size(table_schema || '.' || table_name) as
size FROM information_schema.tables WHERE table_schema NOT IN
('information_schema', 'pg_catalog') ORDER BY size DESC LIMIT 10;
*ERROR: relation "public.contacts" does not exist*
*Original Table : Contacts*
It seems problem is with CAPS letter in Postgres table .
So any possibilities to execute this Caps letter table without any error