home
previous
next
Welcome to Navicat PostgreSQL
Welcome to Navicat PostgreSQL
System Requirements
Feature Matrix
Registration
Installation
Upgrade
License Agreement
Getting Started
Getting Started
Installing PostgreSQL for Windows
Localhost Connection Settings
Remote Connection Settings
First time started
Working with databases
Working with databases objects
Using Navigation Pane
Using connection popup menu
Using database popup menu
Using object popup menu
Virtual Grouping
Connection Settings
Connection Settings
General Settings
SSH Settings
Benefit of SSH Tunneling
Password Authentication
Publich Key Authentication
HTTP Settings
Uploading the Tunneling Script
Setting up HTTP Tunnel
Advanced Settings
Database Management
Database Designer
Editing Database General
Editing Database Privileges
Editing Database Comment
Setting Advanced Database Properties
Database Object Management
Database Object Management
Schemas
Schema Designer
Editing Schema General
Editing Schema Privileges
Editing Schema Comment
Tables
Table Designer
Fields
Setting Field Name and Data Type
Setting Field Size and Decimals
Setting Field Flags
Setting Other Field Properties
Indexes
Setting Index Name and Field Names
Setting Index Type and Flags
Setting Index Tablespace and Constraints
Foreign Keys
Setting Foreign Key Name and Table Fields
Setting On Delete and On Update Actions
Uniques
Setting Unique Name and Field Names
Checks
Setting Check Name and Expression
Rules
Setting Rule Name and Event
Setting Rule Condition and Definition
Triggers
Setting Trigger Name, Time and Statement
Setting Trigger Time and Event
Privileges
Table Options
Setting Table Owner and Tablespace
Setting Table Flag and Inherited Tables
Table Comment
Table Viewer
Data View
Grid View
Using Navigation Bar
Limit Record Setting
Editing Records
Editing Records with Special Handling
Editings Records with Foreign Key
Copying/Pasting Data from/into Navicat
Sorting and Finding Records
Filtering Records
Manipulating Raw Data
Formatting Table Grid
Form View
Text/Blob View
Viewing/Editing Text field as Memo
Viewing/Editing Text/Blob field as Hexadecimal
Viewing/Editing Blob field as Graphical Image
Filter Wizard
Adding New Filter Condition
Setting Filter Criteria
Setting Filter Operator
Setting Filter Criteria Values
Setting Filter Group
Applying Filter Conditions
Views
View Designer
Working with Visual Builder
Editing SQL Definition
Setting Advanced View Properties
Setting View Privileges
Editing View Comment
View Viewer
Functions
Function Designer
Editing Function Definition
Setting Advanced Function Properties
Setting Function Privileges
Editing Function Comment
Viewing Function Result
Aggregates
Aggregate Designer
Editing Aggregate Properties
Editing Aggregate Comment
Conversions
Conversion Designer
Editing Conversion Properties
Editing Conversion Comment
Domains
Domain Designer
Editing Domain General
Editing Domain Check
Editing Domain Comment
Trigger Functions
Trigger Function Designer
Editing Trigger Function Definition
Setting Advanced Trigger Function
Setting Trigger Function Privileges
Editing Trigger Function Comment
Operators
Operator Designer
Editing Operator General
Editing Operator Advanced
Editing Operator Comment
Operator Classes
Operator Class Designer
Editing Operator Class Properties
Editing Operator Class Operators
Editing Operator Class Functions
Editing Operator Class Comment
Sequences
Sequence Designer
Editing Sequence General
Editing Sequence Privileges
Editing Sequence Comment
Types
Type Designer
Editing Type General
Editing Composite Type Definition
Editing Base Type Definition
Editing Type Comment
Tablespaces
Tablespace Designer
Editing Tablespace General
Editing Tablespace Privileges
Casts
Cast Designer
Editing Cast General
Editing Cast Comment
Languages
Language Designer
Editing Language Properties
Editing Language Privileges
Editing Language Comment
Queries
Queries
Query Builder
Working with Diagram Area
Setting Field Association
Setting Output Fields
Setting Criteria
Setting Grouping Criteria
Setting Sorting Criteria
Setting Limit Criteria
Query Editor
Working with Code-Completion
Query Results
Query Parameters
Data Management Tools
Data Management Tools
Import Wizard
Setting Import File Format (Step 1)
Setting Source File Name (Step 2)
Importing ODBC in Step 2
Importing Oracle Data (Step 2)
Importing MSSQL Data (Step 2)
Setting Additional Options for Specific Table Type
Setting Delimiter (Step 3) - TXT, XML
Setting Data Format (Step 4) - TXT, XML, Excel, HTML
Setting Target Table (Step 5)
Adjusting Field Structures and Mapping Fields (Step 6)
Selecting Import Mode (Sep 7)
Saving and Confirming Importing (Step 8)
Export Wizard
Setting Export File Format
Setting Destination File Name and Encoding
Selecting Fields for Export
Setting Data Format
Saving and Confirming Export
Data Transfer
General Settings
Advanced Settings
Message Log
Data Synchronization
General Settings
Advanced Settings
Message Log
Structure Synchronization
General Settings
Advanced Settings
Message Log
Backup/Restore
Backup
General Settings
Advanced Settings
Message Log
Backup by Dumping SQL File
Restore
General Settings
Object Selection
Advanced Settings
Message Log
Restore by Execute Batch File
Extract SQL
Batch Job/Schedule
General Settings
Settings Report Printing
Advanced Settings (E-mail Notification)
Message Log
PostgreSQL Console
Example of Using Console
Print Database/Table Structure
Log Files
Report Management Tools
Report Management Tools
Report Builder Manual
The Basics
Report Wizard
Report Toolbars
Query Wizard
Query Designer
Dialogs
Tutorial on Creating Different Types of Reports
Simple Report
Cover Page
Simple Table Listing
Invoice
Order Summary Report
Detailed Order Summary
Sales Statistics
Crosstab Report
Mailing Label
Form Letter
Photo Album
Server Security Management
Server Security Management
User Management
Group Management
Privileges Provided by PostgreSQL
User Editor
Setting User Membership
Group Editor
Setting Group Member
Setting Database Specific Privileges
Setting Schema Specific Privileges
Setting Function Specific Privileges
Setting Table Specific Privileges
Setting View Specific Privileges
Setting Sequence Specific Privileges
Setting Language Specific Privileges
Setting Tablespace Specific Privileges
Privilege States
PostgreSQL Maintenance Tasks
Analyze
Vacuum
Reindex
Server Monitor
Process List
Variables
Status
Options
Options
General Options
Docking Options
Code Insight Options
Appearance Options
Color Options
Main Window Options
Detail View Options
Data/Grid Options
Display Format Options
Miscellaneous Options
Navicat Support Center
Knowledgebase (Online)
Visual Demo (Online)
Using database popup menu
The popup menu of database in the navigation pane allows you to:
Connect to the selected database.
Disconnect from the selected database.
Create a
new database
.
Delete the selected database.
Set
Database Properties
.
Create a
new schema
.
Open
PostgreSQL Console editor
.
Dump
/
Execute
SQL File.
Print all Data Definition Language(DDL) statements
within the same database.
Maintain a database.
Manage users
.
See also:
Database Management
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.
home
previous
