Pages

Monday, March 21, 2011

How to find connected users to the Databse in Postgres ?

The following query will help to find the connected users in
Postgres database.

select *  FROM pg_stat_activity;




The following query will display the version of
postgres server installed.

SELECT VERSION()

No comments:

Post a Comment