Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
Use the Extension dialog to install a new extension into the current database.
An extension is a collection of SQL objects that add targeted functionality to
your Postgres installation. The Extension dialog adds the functionality of
an extension to the current database only; you must register the extension in
each database that use the extension. Before you load an extension into a
database, you should confirm that any pre-requisite files are installed.
The Extension dialog allows you to implement options of the CREATE EXTENSION
command through the following dialog tabs: General and Definition. The SQL
tab displays the SQL code generated by dialog selections.
Use the fields in the General tab to identify an extension:
Click the Definition tab to continue.
Use the Definition tab to select the Schema and Version:
Click the SQL tab to continue.
Your entries in the Extension dialog generate a SQL command (see an example
below). Use the SQL tab for review; revisit or switch tabs to make any changes
to the SQL command.
The following is an example of the sql command generated by user selections in
the Extension dialog:
The command creates the chkpass extension in the public schema. It is
version 1.0 of chkpass.