Jeff Richards wrote:
>
> Is there a way in postgresql to find the current user status within a
> database like sp_who in Sybase?
since noone has answered you since Tesday, I'll give it a shot. I'm not
familiar with Sybase - does sp_who just return the current Sybase
username? In that case try:
template1=> select getpgusername();
getpgusername
-------------
reedstrm
HTH,
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
