Re: How to catch a command

ok...

in this case the rules don't work, because the db that i use don't
have any data, only the structure. So i need to send the command to
the real databases that are in a diferente server.

So if i use triggers i can't execute select's.

Thks

Humberto Carvalho

On 7/22/05, John DeSoi <desoi(at)pgedit(dot)com> wrote:
>
> 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
>
>

--
Humberto Carvalho