homehome previousprevious nextnext
 
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

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
PGSQL TM is a trademark of PGSQL AB in the United States and other countries.