retrieve pg connection postgres code example

Example: psql connections

SELECT * FROM pg_stat_activity;