Tables Editor (PostgreSQL)
Go Up to PostgreSQL Object Editors
The Tables Editor lets you manage settings for an existing table.
To edit a table
- Open an editor on the table. 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 |
In addition to displaying the identification properties for this table, this tab lets you view the Persistence setting. You can modify the Tablespace, With OIDS, Fill Factor, Table Autovacuum, and Toast Table Autovacuum settings. For details on these properties, see Tables Wizard (PostgreSQL). | |
Ancestors |
This tab/panel lets you modify a table’s INHERITS clause.. For each table to be added to the list, use the New button to enable a dropdown that lets you select a table. Use the Delete button to remove a selected table from the list. | |
Columns |
Displays the currently defined columns in the table. For any selected column, the Property/Value list provides additional detail on that column. Available properties depend on the datatype you choose as well as on the property values you select. For details on working with this tab, see Tables Wizard (PostgreSQL). You can add a column by clicking Add Column, providing a name for the new column, and set its property values. Similarly, select a column and click Delete to remove the column from the table. Lastly, change a columns position by selecting the column and using the arrow buttons. | |
Dependencies |
For details on using this tab, see Working with Object Dependencies. | |
Constraints |
Lets you manage constraints for the table. Constraints are grouped by type, under folders. Optionally take one of the following actions: To add a constraints, select a constraint type folder and click Add to open a dialog that lets you add a constraint of that type. To edit a constraint, select a constraint and click Edit to open a dialog that lets you modify the constraint details. To delete a constraint, select a constraint and click Drop to remove the constraint. | |
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.