Received: from druid.net (root@druid.net [198.96.119.226]) by hub.org (8.9.1/8.9.1) with SMTP id TAA26730 for ; Thu, 12 Nov 1998 19:13:15 -0500 (EST) (envelope-from darcy@druid.net) Received: from localhost (1149 bytes) by druid.net via sendmail with P:stdio/R:inet_hosts/T:smtp (sender: ) (ident using unix) id for ; Thu, 12 Nov 1998 19:12:45 -0500 (EST) (Smail-3.2.0.102 1998-Aug-2 #4 built 1998-Nov-4) Message-Id: From: darcy@druid.net (D'Arcy J.M. Cain) Subject: Re: [SQL] Current User To: ateo@labsd.inf.utfsm.cl (Jorge Maturana) Date: Thu, 12 Nov 1998 19:12:45 -0500 (EST) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <199811112331.UAA12693@rauli.labsd.inf.utfsm.cl> from "Jorge Maturana" at Nov 11, 1998 08:30:59 PM X-Mailer: ELM [version 2.5 PL0b1] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thus spake Jorge Maturana > I want to have a table to manage a register of the modifications made to > several tables by a group of users, that table should contain the name of the > postgres user that made the modificaction, now, How can I get the name (or > the user id) of the current user logged in?,there are some "pg_currentuser" > table to make a select? Look at insert_username in contrib/spi. Basically you create a trigger on insert. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.