Exclusion Constraints, Primary Keys, or Unique Keys Editors (PostgreSQL)
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
- Open an editor on the target object. For details, see Opening an Object Editor.
- 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.