From: pierce at hogranch.com (John R Pierce) Date: Mon, 15 Oct 2012 10:33:57 -0700 Subject: [Pljava-dev] help on trigges In-Reply-To: <1350291995039-5728150.post@n5.nabble.com> References: <1350291995039-5728150.post@n5.nabble.com> Message-ID: <507C4905.2060805@hogranch.com> On 10/15/12 2:06 AM, kostika gorica wrote: > I have an application already running, accessing the database (postgresql > 8.1). I need a solution, that prints (on a file, or somehow) the queries > being executed every time the app accesses the database. > Is there any ON DATABASE ACCESS trigger ?! > Any idea how that can be done? turn on query logging in postgres, done. -- john r pierce N 37, W 122 santa cruz ca mid-left coast