Re: How to catch a command - Mailing list pgsql-novice

On Jul 22, 2005, at 9:13 AM, Humberto Carvalho wrote:

> Anyone know if it's possible to catch a Select, delete, update or
> insert command before he takes effect in the postgres database?
>
> I hope someone can help me.

You can use triggers for delete, update, and insert. Rules can work
on everything including select statements. See

http://www.postgresql.org/docs/8.0/interactive/sql-createrule.html






John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL