Re: Sybase Connection_Property('number') equivalent in PostGre

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