Re: show pool_status like...

Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> writes:
> While I took a look at MySQL manual (mainly for checking query cache
> functionality), I noticed that MySQL has following syntx:

> show .... like 'foo%';

> I think this is usefull for "show pool_status" command since it has
> lengthy output now.

> Usage of show pool_status and like will be something like:

> show pool_status like 'client_idle%' will only show the status of
> client_idle_limit and client_idle_limit_in_recovery.

> Comments?

I think you need to rethink how you've got pool_status defined.
The above kluge isn't going to play nicely at all with the pg_settings
view, for example.

regards, tom lane