How do I list all extensions that are already installed in a database or schema from psql? See also Finding a list of available extensions that PostgreSQL ships with

Because I installed dblink extension into the (default) public schema, \df will display all the dblink related functions. I only want to view customized function. How can I see function that not co...

I'm working on a project that needs to use hstore on multiple schemas. The 'public' schema, where the hstore extension was being installed isn't available everywhere, because my scope doesn't looku...

EDIT : there is no need for an extension anymore. You can now generate a uuid with the function gen_random_uuid() that is available by default since PostgreSQL 14. I am developing an application in...

I am running PostgreSQL 9.5.3 Fedora Linux, and I tried to create the "hstore" extension: CREATE EXTENSION IF NOT EXISTS hstore; But I got this error: could not open extension control ...

I am testing an example for creating a simple base36 PostgreSQL extensions. However, I run into problems when writing and using the unit test case (REGRESS =). If I use sudo make installcheck, the...