Skip to content

Instantly share code, notes, and snippets.

@wayneeseguin
Created December 14, 2011 19:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save wayneeseguin/1478154 to your computer and use it in GitHub Desktop.
Save wayneeseguin/1478154 to your computer and use it in GitHub Desktop.
List installed then available postgresql extensions
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)
postgres=# \dx+
Objects in extension "plpgsql"
Object Description
-------------------------------------------
function plpgsql_call_handler()
function plpgsql_inline_handler(internal)
function plpgsql_validator(oid)
language plpgsql
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment