Re: Questions about triggers,...
Fariba Noorbakhsh wrote:
Show quoted text
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,
Faribaend
Import Notes
Reference msg id not found: 3B3711E4.602B3A21@ccs-munich.de
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:
Show quoted text
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,
Faribaend
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster