Returning schema name with table name - Mailing list pgsql-general

From Andrus
Subject Returning schema name with table name
Date
Msg-id gg6fav$30pm$1@news.hub.org
Whole thread Raw
Responses Re: Returning schema name with table name
Re: Returning schema name with table name
List pgsql-general
SELECT oid, relname::char(35) as Table_Name,
       pg_size_pretty(pg_total_relation_size(oid))::VARCHAR(15) as
Total_Table_Size
FROM pg_class
 where  pg_total_relation_size(oid)/(1024*1024)>0
 ORDER BY pg_total_relation_size(oid) desc

returns table names with size greater than 1 MB

How to modify this so that schema name is also returned?
I have lot of tables with same name and thus this output is difficult to
understand.
pg_class seems not contain schema names.

Andrus.


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Postgres mail list traffic over time
Next
From: Rafael Martinez
Date:
Subject: Re: Using Postgres to store high volume streams of sensor readings