Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (Postfix) with ESMTP id 3A19B475469 for ; Thu, 28 Feb 2002 06:55:29 -0500 (EST) Received: from ara.zf.jcu.cz (LOCALHOST [127.0.0.1]) by LOCALHOST (8.12.0.Beta7/8.12.0.Beta7/Debian 8.12.0.Beta7-1) with ESMTP id g1SBt265032387; Thu, 28 Feb 2002 12:55:03 +0100 Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.12.0.Beta7/8.12.0.Beta7/Debian 8.12.0.Beta7-1) id g1SBt2kM032386; Thu, 28 Feb 2002 12:55:02 +0100 Date: Thu, 28 Feb 2002 12:55:02 +0100 From: Karel Zak To: Jan Oravec Cc: pgsql-sql@postgresql.org Subject: Re: backward SQL query Message-ID: <20020228125502.B20893@zf.jcu.cz> References: <3C7E15BF.000003.01684@elvin.intrak.tuke.sk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3C7E15BF.000003.01684@elvin.intrak.tuke.sk>; from oravecja@intrak.tuke.sk on Thu, Feb 28, 2002 at 12:34:23PM +0100 X-Archive-Number: 200202/449 X-Sequence-Number: 6870 On Thu, Feb 28, 2002 at 12:34:23PM +0100, Jan Oravec wrote: > > I have WEB aplication, whitch browse some data from database. > Can anybody tell me how I can know, which SQL query was used for display > this data, without know source of aplication, whitch use it and when I'm > administrator of this database. I want it use for control which data are > correct and whitch not. See your $(PGDATA)/potgresql.conf and debug_* options, an example debug_print_query. Or may be you can try postmaster "-d" option. More information: http://docs.linux.cz/PostgreSQL/runtime-config.html#LOGGING Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz