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(at)postgresql(dot)org)
>
>

--
Brad Nicholson 416-673-4106 bnichols(at)ca(dot)afilias(dot)info
Database Administrator, Afilias Canada Corp.