Re: [NOVICE] Insert Only Postgresql

On 9/8/06, Brandon Aiken  wrote:
> Sure.  Any RDBMS can do that.  Just create a user account (login role for
> PostgreSQL) and only grant the INSERT privilege to them on your tables, then
> connect with that account with your program.  Any DELETE or UPDATE
> statements will automatically fail.

all tables in postgresql have insert, update, and delete rights you
can grant or revoke.  If you want to be smart and save time, you can
make a procedure to query information_schema and do this automatically
for you with some dynamic sql [hi, karen!] and just call it whenever
you make new tables.

merlin