Is it possible to redirect an update/insert/delete to a different table?

Hello,

Is there a way that I can specify that a request to change to a particular table is redirected instead to a different table?

I’ve looked through rules, and as far as I can make out, they are only useful for explicit actions. I’m looking for something that behaves as though it simply substitutes the table name for a different table name before executing the command, no matter what the command looks like.

Thanks

Andy Ballingall