Rajesh Kumar Mallah wrote:
> But if i were to use DBD::Perl (which probably uses libpq)
> is it safe to pass query indentifier in comments which u
> said are not stripped by psql eg
> /* AppName: Xyzt */ Select foo from bar where cw='t' ;
> for years to come ?
>
> why i ask is that i was always curious of the slow
> long running queries in pg_stat_activity and not able
> to figure out the source had frustrated me , now
> this method if it works seems to me as a viable solution.
I think you have to look try perl to see how it handles it, but I think
it just passes the query whole, so all the comments should pass
themselves to the backend.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073