| Database Management
To start working with databases in Navicat PostgreSQL you are to establish the
connection (see Connection Settings).
Create Database
To create a new database
- Double-click the connection to open in the navigation pane.
- Right-click the opened connection and choose
New Database.
or
- Right-click any existing database and choose
New Database.
- Edit database properties on the appropriate tabs of the Database
Designer.
Edit Database
To edit the existing database(manage its general, privileges etc)
- Right-click the database in the navigation pane and choose
Database Properties....
- Edit database properties on the appropriate tabs of the Database Designer.
Delete Database
To delete a database
- Right-click the database in the navigation pane and choose
Drop Database.
- Confirm removing in the dialog window.
Open Database
To open a hidden database
- Double-click the connection to open in the navigation pane.
- Right-click the opened connection and choose
Open Database.
- Enter the database name.

To open a database which shows in the navigation pane
- Double-click the database to open in the navigation pane.
or
- Right-click the database and choose
Open
Database.
Close Database
To close a database
- Right-click the database in the navigation pane and choose
Close Database
|