2008/11/21 Andrus <kobruleht2@xxxxxx>: > 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 > add SELECT n.nspname and FROM pg_class JOIN pg_catalog.pg_namespace n ON n.oid = pg_class.relnamespace ... Regards Pavel Stehule > 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. > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
