Online Documentation for SQL Manager for PostgreSQL

Table Editor

Table Editor is the basic SQL Manager tool for working with tables. It opens automatically in the New table mode when you create a new table and is available on editing an existing one (see Create table and Edit table for details).

Table Editor allows you to create, edit and drop table's columns, indexes, foreign keys and other table subobjects, manage table data, properties and much more.

To open a table in Table Editor, double-click it in the DB Explorer tree.

• Using Navigation bar and Toolbar
• Managing table columns
• Changing columns order
• Managing table foreign keys
• Managing table checks
• Managing table indexes
• Managing table triggers
• Managing rules
• Managing policies
• Browsing object dependencies
• Working with table data
• Editing table description
• Viewing DDL definition
• Setting object permissions
• Table properties