From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Which trigger execute which function? |
Date: | 2002-03-04 17:28:35 |
Message-ID: | 3C83AEC3.8040106@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser | 2002-03-04 17:39:39 | long vacuum |
Previous Message | Dan Langille | 2002-03-04 16:34:43 | Re: something similar to explain |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-03-04 17:53:17 | Re: vsnprintf and 64-bit Solaris 7 (was: abnormal exits) |
Previous Message | Rick | 2002-03-04 17:24:49 | Migration problem - serial fields |