SELECT COUNT(*) AS total
FROM (
SELECT
DISTINCT usename
FROM pg_stat_activity
) AS x
Em 29 de outubro de 2010 14:45, Emerson Hermann
<[email protected]> escreveu:
> SELECT COUNT(*) AS total
> FROM (
> SELECT
> DISTINCT client_addr
> FROM pg_stat_activity
> ) AS x
>
> Em 29 de outubro de 2010 14:42, Avelino Brun <[email protected]>
> escreveu:
>> Olá colegas!
>>
>> Existe alguma forma de saber quantos usuários existem conectados ao banco de
>> dados?
>>
>> Obrigado
>> Avelino
>>
>> _______________________________________________
>> pgbr-geral mailing list
>> [email protected]
>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>>
>>
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
