Thread: list triggers

list triggers

From
Roman Gavrilov
Date:
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@aduva.com, romio@netvision.net.il