Thread: Re: Questions about triggers,...

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

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
>