Book Image

PostgreSQL Server Programming

Book Image

PostgreSQL Server Programming

Overview of this book

Table of Contents (21 chapters)
PostgreSQL Server Programming Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Viewing extensions


Querying the pg_extension system view or using the meta-command \dx will show the extensions currently installed in the database.

postgres=# \dx
List of installed extensions
-[ RECORD 1 ]-----------------------------
Name        | pgcrypto
Version     | 1.0
Schema      | public
Description | cryptographic functions
-[ RECORD 2 ]-----------------------------
Name        | plperl
Version     | 1.0
Schema      | pg_catalog
Description | PL/Perl procedural language
-[ RECORD 3 ]-----------------------------
Name        | plpgsql
Version     | 1.0
Schema      | pg_catalog
Description | PL/pgSQL procedural language

The extensions that are ready to be installed can be viewed from the pg_available_extensions or pg_available_extension_versions system views.