Exclusion Constraints, Primary Keys, or Unique Keys Editors (PostgreSQL)

From RapidSQL
Jump to: navigation, search

Go Up to PostgreSQL Object Editors

The Exclusion Constraints Editor, Primary Keys Editor, and Unique Keys Editor offer the same steps in modifying these PostgreSQL objects.

To edit an exclusion constraint, primary key, or unique key

  1. Open an editor on the target object. 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 view or modify properties defined when creating the object. For details on these properties, see Exclusion Constraints, Primary Keys, and Unique Keys Wizards (PostgreSQL).

Columns

Lets you work with the columns designated for this object. For details, see Exclusion Constraints, Primary Keys, and Unique Keys Wizards (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.

Statistics

Displays the following pg_stat_all_indexes or pg_statio_all_table view statistics: Scans, Keys Read, Rows Fetched, Blocks Read, Buffer Hits, and Index Size.

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.