Fork me on GitHub

This page in other versions: Latest (8.12) | 8.11 | 8.10 | Development

This document in other formats: PDF | ePub | Tarball

Navigation

DBMS Program

Use the DBMS Program dialog to create a DBMS Program.

DBMS Program dialog general tab

Use the fields in the General tab to create program:

  • Use the Name field to add a descriptive name for the program. The name will be displayed in the pgAdmin object explorer.

  • Use the Enabled? switch to indicate that program should be enabled or disabled.

  • Store notes about the program in the Comment field.

Click the Action tab to continue.

DBMS Program dialog action tab

Use the Action tab to select the action for the program:

  • Use the Type field to select the type of the program. Type could be PLSQL BLOCK or STORED PROCEDURE.

  • Use the Procedure field to select an existing procedure that executes when the program is invoked.

  • Number of Arguments field is read-only and indicates the quantity of arguments necessary for the chosen procedure.

Click the Code tab to continue.

DBMS Program dialog code tab
  • Use the Code field to write the code that executes when the program is invoked. This tab is only enabled when the type of the program is set to ‘PLSQL BLOCK’.

Click the Arguments tab to continue.

DBMS Program dialog arguments tab
  • Arguments tab is a read-only section that outlines the arguments required by the selected procedure in the ‘Action’ tab.

Click the SQL tab to continue.

Your entries in the DBMS Program 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.

Example

The following is an example of the sql command generated by user selections in the DBMS Program dialog:

DBMS Program dialog sql tab
  • Click the Info button (i) to access online help.

  • Click the Help button (?) to access dialog help.

  • Click the Save button to save work.

  • Click the Close button to exit without saving work.

  • Click the Reset button to restore configuration parameters.