On 9/8/06, Brandon Aiken <BAiken@xxxxxxxxxxxxxxx> 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
