Online Documentation for SQL Manager for PostgreSQL

Columns


Table fields are managed within the Fields tab of Table Editor.

 

Creating Columns

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click the tab area and select the New Columns context menu item, or press the Ins key;
  • define the field properties using the Column Editor dialog.

 

Editing Columns

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click the column and select the Edit Column <column_name> context menu item, or simply double-click the column;
  • edit the column properties using the Column Editor dialog.

To change the order of table columns:

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click a column and select the Reorder Columns <column_name> context menu item;
  • edit columns' order using the Reorder Columns dialog.

 

Dropping Columns

  • open the table in Table Editor;
  • proceed to the Columns tab there;
  • right-click the field and select the Drop Column <column_name> context menu item;
  • confirm dropping in the dialog window.