Re: [SQL] audit table containing Select statements submitted

From: "Ben K(dot)" <bkim(at)coe(dot)tamu(dot)edu>
To: "Hogan, James F(dot) Jr(dot)" <JHogan(at)seton(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] audit table containing Select statements submitted
Date: 2006-05-04 17:55:56
Message-ID: Pine.GSO.4.64.0605041251450.5125@coe.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

> Current_user
> Timestamp
> "The Select Statement Submitted by the User"

http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE

might be close to what you want.

Regards,

Ben K.
Developer
http://benix.tamu.edu

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sebastian Wagner 2006-05-04 18:01:56 Re: Googles sommer of Code 2005 - Postgres Project Proposal - where to discuss? who is responsible? who can mentor?
Previous Message Hogan, James F. Jr. 2006-05-04 17:45:59 audit table containing Select statements submitted

Browse pgsql-sql by date

  From Date Subject
Next Message Oisin Glynn 2006-05-04 18:00:57 Re: Connecting to Postgres from other machines (outside localhost)
Previous Message Catalin Pitis 2006-05-04 17:52:29 Connecting to Postgres from other machines (outside localhost)