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