Navicat PostgreSQL download for Windows - Navicat PostgreSQL tool working with Tables

Relational databases use tables to store data. All operations on data are done on the tables themselves or produce another tables as the result. A table is a set of rows and columns, and their intersections are fields. From a general perspective, columns within a table describe the name and type of data that will be found by row for that column's fields. Rows within a table represent records composed of fields that are described from left to right by their corresponding column's name and type. Each field in a row is implicitly correlated with each other field in that row.

Just sample click to open an object pane for Table. A right-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit, open and delete the selected table.

Create Table

To create a new table

Select anywhere on the object pane.
Click the New Table from the object pane toolbar.
or
Right-click and select New Table from the popup menu.
Edit table properties and fields on the appropriate tabs of the Table Designer.

Hint: To create new table you can also right-click the Tables node of the navigation pane and select the New Table from the popup menu.

To create a new table with the same properties as one of the existing tables has (using popup menu)

Apply to: current database {same connection}

Select the table(s) for copying in the navigation pane/object pane.

Right-click and select the Duplicate Table from the popup menu.

The newly created table(s) will be named as "tablename_copy".

To create a new table with the same properties as one of the existing tables has (using drag and drop method)

Apply to: current database {same connection}

Select the table(s) for copying in the navigation pane/object pane.

Right-click and drag the chosen table(s) to the target location.

Select one of the following options:

Copy here (Structure and Data)

Copy here (Structure only)

Move here

Cancel

The newly created table(s) will be named as "tabletname_copy"

Apply to: different database {same connection}

different database {different connection} (Data Transfer tool will be activated)

Select the table(s) for copying in the object pane.

Drag and drop the chosen table(s) to the target database.

Select one of the following options:

Copy here (Structure and Data)

Copy here (Structure only)

Cancel

To create a new table with modification as one of the existing tables

Select the table for modifying in the navigation pane/object pane.
Right-click and select the Design Table from the popup menu.
or
Click the Design Table from the object pane toolbar.
Modify table properties and fields on the appropriate tabs of the Table Designer.
Click Save As.

Create Table Shortcut

To create a table shortcut

Select the table for editing in the navigation pane/object pane.
Right-click and select Create Open Table Shortcut... from the popup menu.
Define the location you wish your shortcut to be saved.

Note: This option is used to provide a convenient way for you to open your table for entering data directly (Grid View/Form View) without activating the main Navicat.

Edit Table

To edit the existing table (manage its fields, indexes, foreign keys and triggers etc)

Select the table for editing in the navigation pane/object pane.
Right-click and select the Design Table from the popup menu.
or
Click the Design Table from the object pane toolbar.
Edit table properties and fields on the appropriate tabs of the Table Designer.

To change the name of the table

Select the table for editing in the navigation pane/object pane.
Right-click and select the Rename from the popup menu.

Open Table (manage table data)

To open a table

Select the table for opening in the navigation pane/object pane.
Right-click and select the Open Table from the popup menu or simply double-click the table.
or
Click the Open Table from the object pane toolbar.

Note: This option is only applied if you do not wish Navicat loads all your images while opening the table. To open the graphical table with faster performance, use Open Table (Quick) below.

To open a table with graphical fields

Select the table for opening in the navigation pane/object pane.
Right-click and select the Open Table (Quick) from the popup menu.

Note: Faster performance for opening the graphical table, as BLOB fields (images) will not be loaded until you click on the cell.

Empty Table

To empty a table

Select the table in the navigation pane/object pane.
Right-click the selected table and choose Empty Table from the popup menu.

Note: This option is only applied when you wish to clear all the existing records without resetting the auto-increment value. To reset the auto-increment value while emptying your table, use Truncate Table below.

Truncate Table

To truncate a table

Select the table in the navigation pane/object pane.
Right-click the selected table and choose Truncate Table from the popup menu.

Delete Table

To delete a table

Select the table for deleting in the navigation pane/object pane.
Right-click and select the Delete Table from the popup menu.
or
Click the Delete Table from the object pane toolbar.
Confirm deleting in the dialog window.

Achieve Table Information

To achieve a table information (OID, owner, primary key, rows, inherited tables and DDL, etc)

Select the table in the navigation pane/object pane.
Right-click the selected table and choose Table Information from the popup menu.