X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 263E89F9C10; Thu, 4 May 2006 14:56:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 98025-06; Thu, 4 May 2006 14:56:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from tamu-relay.tamu.edu (smtp-relay.tamu.edu [165.91.22.120]) by postgresql.org (Postfix) with ESMTP id 89FF99F9B76; Thu, 4 May 2006 14:56:19 -0300 (ADT) Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by tamu-relay.tamu.edu (8.13.6/8.13.3) with ESMTP id k44Hu8Bn000794; Thu, 4 May 2006 12:56:27 -0500 (CDT) (envelope-from bkim@coe.tamu.edu) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p2+Sun/8.11.7) with ESMTP id k44HtuN05644; Thu, 4 May 2006 12:55:56 -0500 (CDT) Date: Thu, 4 May 2006 12:55:56 -0500 (CDT) From: "Ben K." To: "Hogan, James F. Jr." cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] audit table containing Select statements submitted In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Received-SPF: pass (smtp-relay.tamu.edu: 165.91.232.6 is authenticated by a trusted mechanism) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/183 X-Sequence-Number: 94975 > 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