Online Documentation for SQL Manager for PostgreSQL

How To...

 

This section contains brief information about basic operations which can be preformed in SQL Manager for PostgreSQL.

 

Work with Servers

Register Host

Unregister Host

View Server Log SQL Parser

View Server Configuration

View Server Status

 

Work with Databases

Create Database

Register Database

Connect to Database

Disconnect from Database

View Database Info

View Database Registration Info

Enable Login Prompt for Database

Enable System Objects Display

Change Database Default Charset

Change Database Sort Order in DB Explorer

Design Database Visually

Add Objects to Diagram

Extract Database Objects Structure and Data into SQL Script

Backup Database

Restore Database from Backup

Analyze Tables

Vacuum Tables

Reindex

Database Statistics

 

Work with Database and Server Objects

Create New Object

Duplicate Object

Edit Object

Rename Object

Group Objects

Drop Object

Find Object in the Tree

View Object Dependency

View Object DDL

 

Work with Data

Work with Records

Add Records to Table

Edit Record

Save Record in Table

Add Image to Table

Cancel Data Changes

Delete Record from Table

Changing DB font charset

Sorting

Filtering

Grouping

Change Number of Visible Records

Set Data Display Format

Enable\Disable Transaction Confirmation

Export Data

Import Data

Export Data as SQL Script

Load Data

Save Data

 

Work with Queries and Scripts

Work with Queries

Open SQL Editor

Open Visual Query Builder

Create Query

Export Query Results into File

Work with Several Queries at Once

Edit Query in Visual Query Builder

Work with SQL Scripts

Open SQL Script Editor

Create SQL Script

Making Script Work Faster

Create SQL Script Based on Object

Working with Query/Script Text

Execute Query/Script

Save Query/Script as Favorite Query

Load Query/Script from File

Save Query/Script to File

View Executed Queries and Scripts

 

Work with Data Reports

Create Report

Create Simple Report in the Report Designer

Save Report in Database

Save Report to File

View Report

Edit Report

Print Report

 

Work with Metadata Reports

Representing Metadata as Report

Create HTML Report of Database Objects Metadata

View Objects Metadata

Save Report

Viewing HTML Report

Edit Report

Print Report

 

Update SQL Manager

 

Manager Access to Database

Managing users and roles

Granting permissions

 

Managing Changes

Enabling Change Management

Disabling Change Management

Creating Label/Branch/Tag

Checking Repository

Adding Changes to Repository

Releasing New Version of Database

Browsing History of Changes

 

 

---