list triggers

From: Roman Gavrilov <romio(at)il(dot)aduva(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: list triggers
Date: 2002-01-10 14:47:15
Message-ID: 3C3DA973.50676AF6@il.aduva.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I am a bit new to postgresql so please excuse me for my lame questions.

1) How can I see all triggers on specific table or list of triggers in
the database?
2) How can i monitor connections to database some thing equal to "show
processlist" in mysql.
I would like to see who is connected to database.

Thanks in advance.

--
-----------------------------------------------------------------------------
Roman Gavrilov
Aduva Inc., Web Development Services.
work +972-3-7534324 mobile +972-54-834668
romio(at)aduva(dot)com, romio(at)netvision(dot)net(dot)il

Browse pgsql-admin by date

  From Date Subject
Next Message Warren Bakker 2002-01-10 14:59:04 data type comparable to Oracle RAW LONG
Previous Message Timur V. Irmatov 2002-01-10 07:32:34 Re: problem with dumpall