O Emil Rachovsky έγραψε στις Dec 2, 2005 :
>
> I am trying to find out the PostGre equivalent to
> the Sybase function Connection_Property (which returns
> the connection id, given the parameter 'number') ,but
> without success so far. Can anyone tell me how to
> retrieve the connection id in PostGre?
> Thanks in advance,
> Emil
I think pg_backend_pid() and pg_stat_get_backend_pid(integeger)
are your best bets.
>
>
>
> __________________________________
> Start your day with Yahoo! - Make it your home page!
> http://www.yahoo.com/r/hs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
-Achilleus