[GENERAL] Rules on Select

2006-05-05 Thread Sean Hamilton
I have to log each time a user selects data from a table by inserting record in another table. For example I have table xzy user test selects id, name from table xyz. I want to insert into table xyz_log user, action, fields, timestamp test, select, id name, 12/1/05 02:00:21 How can i do this u

[GENERAL] Grant Priviliges on column

2006-03-17 Thread Sean Hamilton
Does Postgres support granting priviliges at the column level? ex. grant update on tableA (id, description) to user ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMA

Re: [GENERAL] [ADMIN] System Tables

2005-10-05 Thread Sean Hamilton
Check out the docs   http://www.postgresql.org/docs/8.0/static/catalogs.html>>> "Adriano Gaspar" <[EMAIL PROTECTED]> 10/5/2005 3:29:27 PM >>> I´m interesting in learning Postgre because I´m working with it now, if you can, i want to know wich are the system tables, and in wich of them can I find