Skip site navigation (1) Skip section navigation (2)

Re: BUG #5370: Shortcut for currently connected users

From: Igor Moiseev <moiseev(dot)igor(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5370: Shortcut for currently connected users
Date: 2010-03-12 09:59:20
Message-ID: 992e34961003120159l5f58fdfaq3bb34cef002dd2ff@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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(at)momjian(dot)us>

> Igor Moiseev wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference:      5370
> > Logged by:          Igor Moiseev
> > Email address:      moiseev(dot)igor(at)gmail(dot)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(at)momjian(dot)us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do
>



-- 
_)) __  __  __
(( ((_( ((_)(|
    _)) moiseev(dot)igor(at)gmail(dot)com

In response to

Responses

pgsql-bugs by date

Next:From: Carlson, JacobDate: 2010-03-12 14:18:48
Subject: Cannot create UTF-8 database
Previous:From: BhavinDate: 2010-03-12 05:23:47
Subject: BUG #5373: Crash at the first time system bootup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group