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 Package dialog to create a (user-defined) package specification.
The Package dialog organizes the management of a package through the following
dialog tabs: General, Header, Body, and Security. The SQL tab displays the SQL
code generated by dialog selections.
Use the fields in the General tab to identify the package:
Click the Header tab to continue.
Use the Header field to define the public interface for the package.
Click the Body tab to continue.
Use the Body field to provide the code that implements each package object.
Click the Security tab to continue.
Use the fields in the Security tab to to assign EXECUTE privileges for the
package to a role. Click the Add icon (+) to set privileges for the package:
Click the Add icon (+) to assign additional privileges; to discard a
privilege, click the trash icon to the left of the row, and confirm the deletion
in the Delete Row popup.
Click the SQL tab to continue.
Your entries in the Package dialog generate a SQL command that creates or
modifies a package definition:
The example shown demonstrates creating a package named empinfo that includes
two function and two procedure.