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: 2005-07-22 15:56:19
Message-ID: 66F1B650-7A60-46F2-83E1-54B2C0FB0753@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Humberto Carvalho 2005-07-22 16:01:36 Re: How to catch a command
Previous Message Joe Siebenmann 2005-07-22 15:36:38 password authentication failed for user ...