Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to catch a command
- From: John DeSoi <desoi(at)pgedit(dot)com>
- To: Humberto Carvalho <carvalho(dot)humberto(at)gmail(dot)com>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: How to catch a command
- Date: Fri, 22 Jul 2005 11:56:19 -0400
- Message-id: <66F1B650-7A60-46F2-83E1-54B2C0FB0753@pgedit.com> <text/plain>
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
- Follow-Ups:
- Re: How to catch a command
- From: Humberto Carvalho
- Re: How to catch a command
- References:
- How to catch a command
- From: Humberto Carvalho
- How to catch a command
- Prev by Date: password authentication failed for user ...
- Next by Date: Re: How to catch a command
- Previous by thread: Re: How to catch a command
- Next by thread: Re: How to catch a command
- Indexes: