Обсуждение: 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 >