From: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
---|---|
To: | Fariba Noorbakhsh <fNoorbakhsh(at)tecways(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Questions about triggers,... |
Date: | 2001-06-27 15:23:31 |
Message-ID: | Pine.LNX.4.21.0106271122480.27771-100000@aluminum.cs.pitt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-27 15:30:54 | Re: Weird error |
Previous Message | Andreas Tille | 2001-06-27 15:11:39 | Re: MS SQL to PostgreSQL |