Re: /* */ comments showing up in pg_stat_activity

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073