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