oracle v$session equivalent in postgresql
| От | |
|---|---|
| Тема | oracle v$session equivalent in postgresql |
| Дата | |
| Msg-id | 20041105152808.GAFG3261.fed1rmmtao07.cox.net@CYGNUS обсуждение исходный текст |
| Ответы |
Re: oracle v$session equivalent in postgresql
|
| Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I’m looking for the equivalent in postgresql to the v$session variables in Oracle. In particular, I
needto convert the following statement:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">select s.program, s.machine into :New.app_name,:New.comp_name from v$session s where
s.audsid=userenv('SESSIONID');</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">Any help appreciated</span></font></div>
В списке pgsql-sql по дате отправления: