Received: from rauli.labsd.inf.utfsm.cl (rauli.labsd.inf.utfsm.cl [200.1.19.100]) by hub.org (8.9.1/8.9.1) with ESMTP id PAA22688 for ; Thu, 12 Nov 1998 15:10:24 -0500 (EST) (envelope-from ateo@rauli.labsd.inf.utfsm.cl) Received: (from ateo@localhost) by rauli.labsd.inf.utfsm.cl (8.8.8/8.8.7) id UAA12693 for pgsql-sql@postgresql.org; Wed, 11 Nov 1998 20:31:00 -0300 (CDT) From: Jorge Maturana Message-Id: <199811112331.UAA12693@rauli.labsd.inf.utfsm.cl> Subject: Current User To: pgsql-sql@postgresql.org Date: Wed, 11 Nov 1998 20:30:59 -0300 (CDT) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi, 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? I would thank any help. -- Jorge Maturana Ortiz Laboratorio de Sistemas Distribuidos - Departamento de Informatica Universidad Tecnica Federico Santa Maria, Valparaiso - Chile mailto:ateo@labsd.inf.utfsm.cl