Обсуждение: triggers procedures listing URGENT

Поиск
Список
Период
Сортировка

triggers procedures listing URGENT

От
"flash"
Дата:
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

От
Haller Christoph
Дата:
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

От
Haller Christoph
Дата:
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?