Current User

Jorge Maturana <ateo@labsd.inf.utfsm.cl>

From: Jorge Maturana <ateo@labsd.inf.utfsm.cl>
To: pgsql-sql@postgresql.org
Date: 1998-11-11T23:30:59Z
Lists: pgsql-sql
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