Re: BUG #5370: Shortcut for currently connected users

Thank you Bruce! This solution is even more flexible!

But how is it possible to know if the docs gives almost nothing

http://search.postgresql.org/search?u=/docs/8.4/static/&q=psqlrc


Thank you.

2010/3/12 Bruce Momjian <bruce@momjian.us>

> Igor Moiseev wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference:      5370
> > Logged by:          Igor Moiseev
> > Email address:      moiseev.igor@gmail.com
> > PostgreSQL version: 8.3.9
> > Operating system:   Ubuntu
> > Description:        Shortcut for currently connected users
> > Details:
> >
> > Dear developers, thank you for the perfect product!
> >
> > I'd like to request one shortcut in psql terminal. That would simplify a
> lot
> > manual administrating of postgresql servers! The query I need always to
> > execute is
> >
> > select * from pg_stat_activity ;
> >
> > That would be nice to have something like "\cu" as a shortcut for this
> > query!!
>
> Add this to your ~/.psqlrc:
>
>        \set mon 'SELECT * FROM pg_stat_activity';
>
> and then you can use this in psql:
>
>        test=> :mon
>         datid | datname | procpid | usesysid | usename  | application_name
> |
>         ...
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do
>



--
_)) __  __  __
(( ((_( ((_)(|
    _)) moiseev.igor@gmail.com