Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C1E2B37B9D9 for ; Thu, 9 Oct 2008 10:23:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73253-02 for ; Thu, 9 Oct 2008 10:23:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f21.google.com (mail-gx0-f21.google.com [209.85.217.21]) by postgresql.org (Postfix) with ESMTP id 9963F37C36D for ; Thu, 9 Oct 2008 10:23:44 -0300 (ADT) Received: by gxk14 with SMTP id 14so9309866gxk.19 for ; Thu, 09 Oct 2008 06:23:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=WsBKR5+1xpGmm3XdgjtsCbakGLI5AIG2atYhiyBUVFo=; b=qrMPF1zgWlKhdI/b1w290KvReLF604JMtrK2q5H2mox+aYP07pzNfsYmDgelJamVFc KWtj8I+dzIK0Sh4qsn35bpZuvmTgNuNXXUbRAsbLuh2yX7RPFJksrvJAyNds4LxmQvob qZyook61EWun1Q7BjzzYb8a3/Iz+erh3p+pNY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=wJ8U8vy87oCkxUMHxjLTbFv25swIAQPdEMYK7k6UpNl7GohIlOcP4pSvlMwcJxh1+0 5A4eQJ5pVd4hMMwMr7gbzUYMgcYAqYupkEjerQAVAky3cm7G2NtX7ZHxVV+PZqou7PsW hJpPO+8NMd37dWZ0dWW3CgdqtnA1FBxTyHmLo= Received: by 10.150.98.18 with SMTP id v18mr126669ybb.232.1223558622966; Thu, 09 Oct 2008 06:23:42 -0700 (PDT) Received: by 10.150.196.12 with HTTP; Thu, 9 Oct 2008 06:23:42 -0700 (PDT) Message-ID: Date: Thu, 9 Oct 2008 18:53:42 +0530 From: "c k" To: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: logging SQL statements MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_121123_8179993.1223558622954" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200810/67 X-Sequence-Number: 30523 ------=_Part_121123_8179993.1223558622954 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Is it possible to log all sql statements submitted to database server in a table in that database it self? This will be different from database logs which are written by db server. Regards, CPK ------=_Part_121123_8179993.1223558622954 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Is it possible to log all sql statements submitted to database server in a table in that database it self? This will be different from database logs which are written by db server. 

Regards,
CPK
------=_Part_121123_8179993.1223558622954--