Returning schema name with table name

Поиск
Список
Период
Сортировка
От Andrus
Тема Returning schema name with table name
Дата
Msg-id gg6fav$30pm$1@news.hub.org
обсуждение исходный текст
Ответы Re: Returning schema name with table name  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Returning schema name with table name  (Thomas Markus <t.markus@proventis.net>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Postgres mail list traffic over time
Следующее
От: Rafael Martinez
Дата:
Сообщение: Re: Using Postgres to store high volume streams of sensor readings