Online Documentation for SQL Manager for PostgreSQL

Managing columns


The Columns tab is intended for managing table columns.

 

Hint: This tab is selected by default upon opening Table Editor if the Always open the first tab option is enabled on the Tools | Object Editors page of the Environment Options dialog.

 

Double-click a column to open Column Editor for editing the column.

 

Right-click a column to display the context menu allowing you to create new, edit, drop, rename, duplicate the selected column, or reorder columns of the table. Using the menu you can also copy to clipboard or export the list of the table columns to any of supported formats.

 

Columns management tools are also available through the Navigation bar and toolbar of Table Editor.

 

Table Editor - Managing fields

 

 

The Columns list provides the following attributes of each column of the table:

Column Name

Column Type

Key

Not Null

Default

Description

 

For details see Columns.

 

If necessary, you can also use the Column Description area to supply a description for each column.