On Mon, May 01, 2006 at 05:23:22PM -0700, Karen Hill wrote: > Tried it but didn't work. It gave me a hint though to try triggers. > Can anyone show me how to do an insert into a view using triggers? Rules are probably what you're after; the documentation has examples. http://www.postgresql.org/docs/8.1/interactive/rules.html http://www.postgresql.org/docs/8.1/interactive/rules-update.html#RULES-UPDATE-VIEWS -- Michael Fuhr