Re: Logging and Viewing SQL History - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Logging and Viewing SQL History
Date
Msg-id 20060610202900.GA4334@webserv.wug-glas.de
Whole thread Raw
In response to Logging and Viewing SQL History  ("Adam" <adam@spatialsystems.org>)
List pgsql-general
am  10.06.2006, um 14:09:36 -0500 mailte Adam folgendes:
> I tried searching for this but didn't see anything.
>
> Is there a way I can see the last 5 or last 1 SQL statements that have been
> run on the server?  I'm using 8.1.3 ---------------------------(end of

'log_statement = all'

in your postgresql.conf

Than can you see all of your SQL-Statements in the log.


Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: "Adam"
Date:
Subject: Logging and Viewing SQL History
Next
From: "Pat Maddox"
Date:
Subject: Questions about indexes