Re: proposal - psql - show longest tables

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: proposal - psql - show longest tables
Дата
Msg-id m2a9lei810.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответ на Re: proposal - psql - show longest tables  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: proposal - psql - show longest tables
Re: proposal - psql - show longest tables
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
>> SELECT * from top5();
 $ TABLE top5;  -- add a view on top of the SRF

> you cannot use parameters - then I have to have prepared files like
> top10, top20, ... what is not too friendly

The SRF could be using custom GUCs so that you can parametrize it, or
just even classic parameters…
 $ TABLE top(5);  -- needs a patch to accept SRF here… $ TABLE top LIMIT 5;
 $ SET top.limit = 5; $ TABLE top;

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



В списке pgsql-hackers по дате отправления: