Online Documentation for SQL Manager for PostgreSQL

Managing indexes


The Indices tab is provided for managing table indexes. Double-click an index to open Index Editor for editing the index.

 

Right-click an index to display the context menu allowing you to create new, edit, drop, reindex the selected index, or reindex all indexes. Using the menu you can also export the list of the table indexes to any of supported formats.

 

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

 

Table Editor - Managing indexes

 

The Indexes list provides the following attributes of each index of the table:

Index Name

Function

On Column(s)

Type

Unique

Primary Key

Where

Description

 

For details see Indexes.

 

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