Raymond Chui wrote: > Previous DBA create a lot of triggers and functions without > documentation like: > > CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name > FOR EACH ROW EXECUTE PROCEDURE function_name(); > > Now he is gone. I couldn't find his PL/PGSQL source codes! > > I can do > > SELECT * FROM pg_proc; > SELECT * FROM pg_trigger; > > to list all the name of triggers and functions. But I don't know which > trigger > execute which function. How do I find out that? > > Our USENET new server (NNTP) doesn't have comp.databases.postgresql.* > news groups. Therefore, please cc: a copy to me if you reply. > Thank Q very much in advance! >
You could use "pg_dump -s > mydb.dmp" to dump the database schema. Then open mydb.dmp in a text editor. I think this will show you all the details you need. HTH, Joe ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
