Skip to content

Instantly share code, notes, and snippets.

@Randommood
Forked from wayneeseguin/gist:1478154
Created December 14, 2011 20:28
Show Gist options
  • Save Randommood/1478360 to your computer and use it in GitHub Desktop.
Save Randommood/1478360 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