Functions Editor (PostgreSQL)

From DBArtisan
Jump to: navigation, search

Go Up to PostgreSQL Object Editors

The Functions Editor lets you view or modify the function body, parameters, and properties for a function.

To edit a function

  1. Open an editor on the function. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you modify the settings defined when the function was created or last edited. For details on these properties, see Functions Wizard (PostgreSQL).

Parameters

Lets you modify the function inputs and outputs defined when the function was created or last edited. For details on these settings on this tab, see Functions Wizard (PostgreSQL).

Body

Lets you modify the function definition specified when the function was created or last edited. For details on working with this tab, see Functions Wizard (PostgreSQL).

Dependencies

For details on using this tab, see Working with Object Dependencies.

Comment

For details on using this tab, see Adding a Comment to an object.

Permissions

For details on using this tab, see Working with Privileges and Permissions.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.