Postgresql version and extensions that are installed

To see the PostgreSQL version number:
select version();

To see which extensions are present:
select * from pg_extension;