Postgres Pro
Downloads
Home   >   mailing lists

Thread: triggers procedures listing URGENT

triggers procedures listing URGENT

From
"flash"
Date:
Hi Friends,

I'm just a beginner, partaking in a project.

Is there any way to list or edit the user-defined
procedures, functions and triggers?

I have already loaded them into the postgres database
and trying to edit and list it.



thanks,
francis


Re: triggers procedures listing URGENT

From
Haller Christoph
Date:
Have a look into the system tables 
pg_proc
pg_trigger

Have a look into the documentation, 
refer to System Catalogs

Within psql you get 
System Catalogs listed by \dS
specific information about a table 
by i. e. \d pg_proc

Regards, Christoph

Re: triggers procedures listing URGENT

From
Haller Christoph
Date:
Within psql 
examine the system tables 
pg_proc
pg_trigger

Refer to the documentation 
Chapter System Catalogs 

Regards, Christoph 

PS
I was sending this mail yesterday 
to 'pgsql-hackers@postgresql.org' 
but it seemed to disappear, 
at least I did not get it back. 
Has anybody experienced similar effects?