Re: how to capture query?

To log all queries - in your postgresql.conf file, set the following:
log_statement = true

Mark wrote:

>Hi,
>I'm getting some errors in log file saying "invalid character at
>position
>#20..." I know that this is most likely that query is wrong.
>
>Is it possible to capture all queries that get send or at least the
>invalid queries?
>
>I'm using postgresql 7.4.3 on Red Hat 9
>
>Thanks,
>Mark
>
>
>
>__________________________________
>Do you Yahoo!?
>The all-new My Yahoo! - What will yours do?
>http://my.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>


--
Brad Nicholson  416-673-4106    bnichols@ca.afilias.info
Database Administrator, Afilias Canada Corp.