Close a user connection to a database in Postgresql

select * from pg_catalog.pg_stat_activity;

select pg_terminate_backend(pid)
from pg_catalog.pg_stat_activity
where pid = [nr found in column pid from previous query]