Richard's postgresql-tips repository has something on that:
http://www.archonet.com/pgdocs/chap-systbl.html#VIEW-TRIGGERS
cheers,
thalis
On Wed, 27 Jun 2001, Fariba Noorbakhsh wrote:
>
>
> Fariba Noorbakhsh wrote:
>
> >
> > Hello ,
> > Can anybody help me with these two qusestions?!
>
> >
> > 1. Question about triggers:
> > How can I see a list of triggers, I have created for a table. I know we
> > don't have any show command on PostgreSQL, so is there any other way to
> > do it?!!!
> >
> > 2. Question about Database location:
> > How can I find the location of database?!
> > I tried /usr/local/pgsql/data, but there isn't any database name like "
> >
> > testdb", which I have created with "psql testdb" command!!!!
> >
> > Thanks in Advance,
> > Fariba
> >
> > end
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>