Fix EXTENSIONS section for pgsql

This should have been pgsql, not psql...

Port skipif.inc files to EXTENSIONS

Convert resources to objects in ext/pgsql

Closes GH-6791

Co-authored-by: Nikita Popov <nikita.ppv@gmail.com>