• Welcome to Navicat PostgreSQL
• System Requirements
• Feature Matrix
• Registration
• Installation
• Upgrade
• License Agreement

• 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
• 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
• 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