Re: [GENERAL] Calls to find Users and databases open...

2004-04-30 Thread Martin Marques
El Vie 30 Abr 2004 11:16, Thomas LeBlanc escribió: > What are the SQL commands to find who is logged on a server, what database > he/she has open, etc? > > Where is this information in the help file or documentation? select * from pg_stat_activity; -- 11:47:01 up 1 day, 17:09, 3 users, load a

[GENERAL] Calls to find Users and databases open...

2004-04-30 Thread Thomas LeBlanc
What are the SQL commands to find who is logged on a server, what database he/she has open, etc? Where is this information in the help file or documentation? Thanks, Thomas _ FREE pop-up blocking with the new MSN Toolbar – get it now