postgres get connection details code example

Example: psql connections

SELECT * FROM pg_stat_activity;