Online Documentation for SQL Manager for PostgreSQL
![]() |
Welcome to SQL Manager for PostgreSQL! |
![]() |
What's new? |
![]() |
System requirements |
![]() |
Feature Matrix |
![]() |
Installation |
![]() |
Registration |
![]() |
How to register SQL Manager |
![]() |
Version history |
![]() |
EMS SQL Manager FAQ |
![]() |
Other EMS Products |
![]() |
Getting Started |
![]() |
Selecting style and language |
![]() |
First time started |
![]() |
Using Desktop Panel |
![]() |
Database navigation |
![]() |
Working with database objects |
![]() |
Using context menus |
![]() |
Host context menu |
![]() |
Database context menu |
![]() |
Object context menu |
![]() |
Working with windows |
![]() |
Database Explorer |
![]() |
Managing database registration info |
![]() |
Connecting to databases |
![]() |
Operations with database objects |
![]() |
Selecting multiple objects |
![]() |
Using tabs for database navigation |
![]() |
Recently opened objects |
![]() |
Searching within the tree |
![]() |
SQL Assistant |
![]() |
Configuring Database Explorer |
![]() |
Managing Favorite queries |
![]() |
Database Management |
![]() |
Create Database wizard |
![]() |
Setting database name |
![]() |
Setting connection properties |
![]() |
Specifying tunneling parameters |
![]() |
Setting advanced database properties |
![]() |
Viewing result SQL statement |
![]() |
Register Database wizard |
![]() |
Setting connection parameters |
![]() |
Specifying tunneling parameters |
![]() |
Selecting databases |
![]() |
Setting specific options |
![]() |
Database Registration Info |
![]() |
Connection |
![]() |
Options |
![]() |
Session settings |
![]() |
Display options |
![]() |
Directories |
![]() |
Logs |
![]() |
SSL options |
![]() |
SSH tunneling options |
![]() |
HTTP tunneling options |
![]() |
Data options |
![]() |
Change management |
![]() |
Repository management wizard |
![]() |
Selecting operation |
![]() |
Selecting version control provider |
![]() |
Configuring provider settings |
![]() |
CVS |
![]() |
SVN/VSS |
![]() |
TFS |
![]() |
Specifying repository settings |
![]() |
Defining label options |
![]() |
Performing operation |
![]() |
Configuring provider settings |
![]() |
CVS |
![]() |
SVN |
![]() |
VSS |
![]() |
TFS |
![]() |
Version Control Branches |
![]() |
Find Option |
![]() |
Database Properties |
![]() |
General |
![]() |
Description |
![]() |
Permissions |
![]() |
Find Option |
![]() |
Database Registration Manager |
![]() |
Using Navigation bar and Toolbar |
![]() |
Database Objects Management |
![]() |
New Object |
![]() |
Duplicate Object Wizard |
![]() |
Selecting the source database |
![]() |
Selecting object to duplicate |
![]() |
Selecting destination database |
![]() |
Modifying the new object's definition |
![]() |
Schemas |
![]() |
Schema Editor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing schema |
![]() |
Schema Objects |
![]() |
Tables |
![]() |
New table |
![]() |
Using Navigation bar and Toolbar |
![]() |
Setting table properties |
![]() |
Specifying columns |
![]() |
Foreign table options |
![]() |
Table Editor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Managing columns |
![]() |
Changing columns order |
![]() |
Managing foreign keys |
![]() |
Managing checks |
![]() |
Managing indexes |
![]() |
Managing triggers |
![]() |
Managing rules |
![]() |
Table properties |
![]() |
Managing policies |
![]() |
Working with table data |
![]() |
Table Services |
![]() |
Analyze & Vacuum Table |
![]() |
Setting analyze parameters |
![]() |
Selecting columns to analyze |
![]() |
Running service |
![]() |
Cluster Table |
![]() |
Selecting index for clustering |
![]() |
Running service |
![]() |
Truncate Table |
![]() |
Running service |
![]() |
Reindex Table |
![]() |
Running service |
![]() |
Columns |
![]() |
Columns Editor |
![]() |
Editing column definition |
![]() |
Foreign Keys |
![]() |
Foreign Key Editor |
![]() |
Editing foreign key definition |
![]() |
Checks |
![]() |
Check Editor |
![]() |
Editing check definition |
![]() |
Indexes |
![]() |
Index Editor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Editing index definition |
![]() |
Policies |
![]() |
Policy Editor |
![]() |
Editing Policy Definition |
![]() |
Views |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing view |
![]() |
Managing columns |
![]() |
Managing indexes |
![]() |
Managing rules |
![]() |
Managing triggers |
![]() |
Working with data |
![]() |
Functions |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing function |
![]() |
Setting configuration parameters |
![]() |
Executing functions |
![]() |
Specifying input parameters |
![]() |
Debugger |
![]() |
Using Navigation bar and Toolbar |
![]() |
Debugging |
![]() |
Browsing debug information |
![]() |
Procedures |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing procedure |
![]() |
Domains |
![]() |
Using Navigation bar and Toolbar |
![]() |
Managing domain checks |
![]() |
Creating/editing domain |
![]() |
Rules |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing rule |
![]() |
Triggers |
![]() |
Using Navigation bar and Toolbar |
![]() |
Editing trigger definition |
![]() |
Sequences |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing sequence |
![]() |
Base Types |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing base type |
![]() |
Composite Types |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing composite type |
![]() |
Enumerated Types |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing ENUM type |
![]() |
Range Types |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing range type |
![]() |
Aggregates |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing aggregate |
![]() |
Operators |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing operator |
![]() |
Collations |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing collation |
![]() |
Statistics |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing statistics |
![]() |
Non-schema Objects |
![]() |
Event triggers |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing event trigger |
![]() |
Tablespaces |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing tablespace |
![]() |
Languages |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing language |
![]() |
Foreign Servers |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing foreign server |
![]() |
User mapping |
![]() |
Foreign Data Wrappers |
![]() |
Using Navigation bar and Toolbar |
![]() |
Creating/editing foreign data wrapper |
![]() |
Local Scripts |
![]() |
Shared scripts |
![]() |
TFS |
![]() |
CVS |
![]() |
VSS |
![]() |
SVN |
![]() |
Change Management |
![]() |
Create branch/label/tag wizard |
![]() |
Selecting source database |
![]() |
Selecting operation |
![]() |
Setting created object options |
![]() |
Specifying connection settings |
![]() |
Performing operation |
![]() |
Check repository wizard |
![]() |
Selecting database |
![]() |
Selecting object types |
![]() |
Checking repository |
![]() |
Specifying action for each difference |
![]() |
Selecting objects to remove from the repository |
![]() |
Checking and correcting script |
![]() |
Adding comments |
![]() |
Performing operation |
![]() |
Get change script wizard |
![]() |
Selecting source database |
![]() |
Selecting script generation method |
![]() |
Specifying start and end points for the script |
![]() |
Specifying comments |
![]() |
Specifying script destination |
![]() |
Performing operation |
![]() |
Release new version of database |
![]() |
Selecting versions source |
![]() |
Checking repository |
![]() |
Specifying actions for problems to resolve |
![]() |
Selecting objects to delete from repository |
![]() |
Checking and correcting script |
![]() |
Specifying comments |
![]() |
Performing repository correction |
![]() |
Creating label/tag |
![]() |
Specifying label options |
![]() |
Performing label creation |
![]() |
Generating change script |
![]() |
Selecting method of script generation |
![]() |
Specifying comments |
![]() |
Performing script generation |
![]() |
Specifying script to test |
![]() |
Selecting the way of getting test database |
![]() |
Specifying test database location |
![]() |
Performing test database creation |
![]() |
Confirming checking test database |
![]() |
Performing comparison of test database with the previous version of database |
![]() |
Bringing test database to previous version of database state |
![]() |
Executing change script on test database |
![]() |
Performing comparison of test database with the new version of database |
![]() |
Specify action for the test database |
![]() |
Finishing the operation |
![]() |
History |
![]() |
History of database changes |
![]() |
Object history |
![]() |
Comparing object versions |
![]() |
Query Management Tools |
![]() |
Query Data |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with Query Data area |
![]() |
Using the context menu |
![]() |
Viewing query plan |
![]() |
Adding objects to query |
![]() |
Using object links |
![]() |
Executing queries |
![]() |
Viewing query logs |
![]() |
Favorites editor |
![]() |
Design Query |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with diagram area |
![]() |
Joining two objects |
![]() |
Setting criteria |
![]() |
Setting output fields |
![]() |
Setting grouping criteria |
![]() |
Setting sorting parameters |
![]() |
Working with the editor area |
![]() |
Query execution |
![]() |
Viewing query plan |
![]() |
Query parameters |
![]() |
Input parameters dialog |
![]() |
Data Management |
![]() |
Data View |
![]() |
Using Navigation bar and Toolbars |
![]() |
Grid View |
![]() |
Customizing columns |
![]() |
Grouping and sorting data |
![]() |
Filtering records |
![]() |
Using the context menu |
![]() |
Working in multi-level mode |
![]() |
Create Grid Level wizard |
![]() |
Specifying master level |
![]() |
Defining source for detail level |
![]() |
Binding master and detail levels |
![]() |
Query parameterization |
![]() |
Setting additional parameters |
![]() |
Working in card view mode |
![]() |
Column Summary |
![]() |
Copying records |
![]() |
Form View |
![]() |
Print Data |
![]() |
Page Setup |
![]() |
Page |
![]() |
Margins |
![]() |
Header/Footer |
![]() |
Scaling |
![]() |
Report Formatter |
![]() |
View |
![]() |
Behaviors |
![]() |
Formatting |
![]() |
Styles |
![]() |
Preview |
![]() |
Cards |
![]() |
Charts |
![]() |
Setting report options |
![]() |
Print dialog |
![]() |
BLOB View |
![]() |
Navigation within BLOB Editor |
![]() |
Editing as Hexadecimal |
![]() |
Editing as Text |
![]() |
Editing as Rich Text |
![]() |
Editing as Image |
![]() |
Editing as HTML |
![]() |
Editing as XML |
![]() |
Editing as PDF |
![]() |
Editing as JSON |
![]() |
Applying changes |
![]() |
Custom Filter |
![]() |
Filter Builder dialog |
![]() |
Invoking the Filter Builder dialog |
![]() |
Adding a new condition |
![]() |
Setting filter criteria |
![]() |
Setting filter operator |
![]() |
Setting filter criteria values |
![]() |
Adding a new group |
![]() |
Setting group operator |
![]() |
Applying filter conditions |
![]() |
Import/Export Tools |
![]() |
Export Data Wizard |
![]() |
Setting destination file name and format |
![]() |
Selecting columns for export |
![]() |
Adjusting data formats |
![]() |
Setting header and footer |
![]() |
Setting format-specific options |
![]() |
Excel 97-2003 options |
![]() |
Data format |
![]() |
Columns |
![]() |
Options |
![]() |
Styles |
![]() |
Extensions |
![]() |
Hyperlinks |
![]() |
Notes |
![]() |
Charts |
![]() |
Cells |
![]() |
Merged Cells |
![]() |
Advanced |
![]() |
Access options |
![]() |
RTF options |
![]() |
Base Styles |
![]() |
Strip Styles |
![]() |
HTML options |
![]() |
Preview |
![]() |
Basic |
![]() |
Multi-file |
![]() |
Advanced |
![]() |
PDF options |
![]() |
TXT options |
![]() |
CSV options |
![]() |
XML options |
![]() |
MS Excel / ODS options |
![]() |
MS Word / ODT options |
![]() |
Setting common export options |
![]() |
Exporting data |
![]() |
Import Data Wizard |
![]() |
Selecting source file name and format |
![]() |
Selecting data source |
![]() |
Setting columns correspondence |
![]() |
Excel 97-2003 |
![]() |
Access, DBF, XML Datapacket |
![]() |
TXT |
![]() |
CSV |
![]() |
HTML |
![]() |
XML Generic |
![]() |
MS Excel/Word, ODF |
![]() |
Adjusting data formats |
![]() |
Setting advanced column formats |
![]() |
Setting import mode |
![]() |
Customizing common options |
![]() |
Importing data |
![]() |
Export as SQL Script |
![]() |
Selecting destination DBMS |
![]() |
Setting destination file name |
![]() |
Setting BLOB options |
![]() |
Selecting column to export |
![]() |
Setting export options |
![]() |
Editing table definition |
![]() |
Exporting as SQL Script |
![]() |
Save Data Wizard |
![]() |
Setting output file name |
![]() |
Selecting columns |
![]() |
Specifying type of output file |
![]() |
Setting output file parameters |
![]() |
Saving data |
![]() |
Load Data Wizard |
![]() |
Setting input file name |
![]() |
Selecting columns |
![]() |
Specifying type of input file |
![]() |
Specifying input file parameters |
![]() |
Loading data |
![]() |
Tools |
![]() |
Dependency Tree |
![]() |
Using Navigation bar and Toolbar |
![]() |
Viewing dependency tree |
![]() |
SQL Monitor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with SQL Monitor |
![]() |
Execute Script Editor |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with Execute Script editor area |
![]() |
Using Script Explorer |
![]() |
Script execution |
![]() |
Extract Database |
![]() |
Selecting source database |
![]() |
Specifying destination file name |
![]() |
Setting extraction mode |
![]() |
Selecting objects for structure extraction |
![]() |
Selecting objects for data extraction |
![]() |
Customizing script options |
![]() |
Start of extraction process |
![]() |
Copy Database |
![]() |
Selecting source database |
![]() |
Specifying destination database |
![]() |
Selecting components to copy |
![]() |
Selecting objects to copy their structure |
![]() |
Selecting objects to copy their data |
![]() |
Setting additional options |
![]() |
Copying database |
![]() |
Compare Databases |
![]() |
Selecting source database |
![]() |
Selecting target database |
![]() |
Selecting type of the syncrhonization script |
![]() |
Defining options for destination script |
![]() |
Performing operation |
![]() |
Print Metadata |
![]() |
Using Navigation bar and Toolbar |
![]() |
Printing options |
![]() |
Print preview |
![]() |
HTML Report Wizard |
![]() |
Selecting database and directory |
![]() |
Selecting object types |
![]() |
Specifying CSS |
![]() |
Setting additional report options |
![]() |
Creating HTML report |
![]() |
Reports management |
![]() |
Create Report Wizard |
![]() |
Specifying database name and report options |
![]() |
Selecting report bands |
![]() |
Selecting report style |
![]() |
Specifying page settings |
![]() |
Specifying paper settings |
![]() |
Specifying margins |
![]() |
Specifying other page settings |
![]() |
Report Designer |
![]() |
Adding dialog form |
![]() |
Adding database and query components |
![]() |
Adding report data |
![]() |
Viewing the report |
![]() |
Saving the report |
![]() |
Report Viewer |
![]() |
Using Navigation bar and Toolbar |
![]() |
Search in Metadata |
![]() |
Using Navigation bar and Toolbar |
![]() |
Setting search conditions |
![]() |
Viewing search results |
![]() |
Database Designer |
![]() |
Using Navigation bar and Toolbars |
![]() |
Using Diagram Navigator and DB Objects panel |
![]() |
Using context menus |
![]() |
Working with diagram objects |
![]() |
Adding/removing objects to/from diagram |
![]() |
Incremental search |
![]() |
Creating objects |
![]() |
Creating relations |
![]() |
Working with diagram pages |
![]() |
Reverse engineering |
![]() |
Printing diagram |
![]() |
Print Preview |
![]() |
Print Setup dialog |
![]() |
Saving/loading diagram |
![]() |
Setting diagram options |
![]() |
External Tools |
![]() |
External Tools dialog |
![]() |
External Tool Info editor |
![]() |
Roles and Privileges |
![]() |
User Manager |
![]() |
Using Navigation bar and Toolbar |
![]() |
Managing users |
![]() |
Group Manager |
![]() |
Using Navigation bar and Toolbar |
![]() |
Managing groups |
![]() |
Role Editor |
![]() |
Editing properties |
![]() |
Selecting role members |
![]() |
Defining user/group membership |
![]() |
Grant Manager |
![]() |
Using Navigation bar, Toolbar and context menu |
![]() |
Managing database-specific privileges |
![]() |
Filtering objects in list |
![]() |
Services |
![]() |
Analyze Tables |
![]() |
Selecting database |
![]() |
Selecting tables to be analyzed |
![]() |
Analyzing tables |
![]() |
Vacuum Tables |
![]() |
Selecting database |
![]() |
Setting vacuum parameters |
![]() |
Selecting tables |
![]() |
Vacuuming tables |
![]() |
Reindex |
![]() |
Selecting database |
![]() |
Setting reindex options |
![]() |
Selecting objects to reindex |
![]() |
Reindexing objects |
![]() |
Download Files |
![]() |
Selecting download method |
![]() |
Selecting database |
![]() |
FTP/SFTP connection setup |
![]() |
Specifying operation and selecting files |
![]() |
Database Statistics |
![]() |
Using Navigation bar and Toolbar |
![]() |
Browsing Column Statistics |
![]() |
Diagram view |
![]() |
Browsing Object Statistics |
![]() |
Browsing Database Statistics |
![]() |
Saving/loading statistics |
![]() |
Statistics Collector options |
![]() |
Backup Database |
![]() |
Selecting host |
![]() |
Specifying SSH tunneling parameters |
![]() |
Specifying objects to backup |
![]() |
Setting output format and file name |
![]() |
Setting backup options for database objects |
![]() |
Selecting objects to be included |
![]() |
Selecting objects to be excluded |
![]() |
Setting additional backup options |
![]() |
Setting backup creation options |
![]() |
Running database backup |
![]() |
Restore Database |
![]() |
Selecting host |
![]() |
Specifying SSH tunneling parameters |
![]() |
Selecting source file for restoring |
![]() |
Script conversion |
![]() |
Selecting restore type |
![]() |
Setting restore options for database objects |
![]() |
Selecting objects to restore |
![]() |
Setting additional restore options |
![]() |
Setting restore process options |
![]() |
Running database restore |
![]() |
Instance Manager |
![]() |
Using Navigation and Toolbar Bar |
![]() |
Server Status |
![]() |
Using Navigation bar and Toolbar |
![]() |
Viewing Connections |
![]() |
Viewing Locks |
![]() |
Managing Prepared Transactions |
![]() |
Viewing Logfile |
![]() |
Server Log SQL Parser |
![]() |
Using Navigation bar and Toolbar |
![]() |
Working with Server Log SQL Parser |
![]() |
Server Configuration |
![]() |
Viewing Parameters |
![]() |
Modifying Role Settings |
![]() |
Setting up Configuration Files |
![]() |
Changing HBA File |
![]() |
Changing Ident File |
![]() |
Extensions |
![]() |
Using Navigation and Toolbar Bar |
![]() |
Install/Update Extensions |
![]() |
Options |
![]() |
Environment Options |
![]() |
Preferences |
![]() |
Full mode activation |
![]() |
Confirmations |
![]() |
Appearance |
![]() |
Tools |
![]() |
Timeouts |
![]() |
DB Explorer |
![]() |
Search |
![]() |
Object Editors |
![]() |
Query Data |
![]() |
SQL Monitor |
![]() |
Execute Script |
![]() |
Design Query |
![]() |
Style & Color |
![]() |
Database Designer |
![]() |
Print Metadata |
![]() |
Data Export |
![]() |
Fonts |
![]() |
Grid |
![]() |
Data Options |
![]() |
Print Data |
![]() |
Color & Formats |
![]() |
Advanced |
![]() |
Column Options |
![]() |
Localization |
![]() |
Global Shortcuts |
![]() |
Find Option |
![]() |
Editor Options |
![]() |
General |
![]() |
Display |
![]() |
Color Scheme |
![]() |
Code Completion |
![]() |
SQL Formatter |
![]() |
SQL Words |
![]() |
Key Mapping |
![]() |
Spell Checking |
![]() |
Find Option |
![]() |
Save Settings |
![]() |
Specifying destination file |
![]() |
Selecting settings |
![]() |
Selecting databases |
![]() |
Saving settings |
![]() |
Localization |
![]() |
Localization Editor |
![]() |
Select Program Language |
![]() |
Keyboard Templates |
![]() |
Object Templates |
![]() |
Find Option dialog |
![]() |
Appendix |
![]() |
Program interface |
![]() |
Viewing object DDL structure |
![]() |
Editing object description |
![]() |
Browsing object dependencies |
![]() |
Setting object permissions |
![]() |
Changing Metadata window |
![]() |
Find Text dialog |
![]() |
Replace Text dialog |
![]() |
Host Login dialog |
![]() |
Add parameter |
![]() |
Format specifiers |
![]() |
Language Info Editor |
![]() |
Using templates |
![]() |
Supported file formats |
![]() |
To-Do List |
![]() |
Windows List |
![]() |
Customize toolbars and menus |
![]() |
SSH tunneling options |
![]() |
HTTP tunneling options |
![]() |
SQL Manager Direct |
![]() |
Database Login dialog |
![]() |
Overwriting existing output file |
![]() |
Script conversion |
![]() |
Select Object dialog |
![]() |
SQL Manager shortcuts |
![]() |
How to... |
![]() |
Work with Databases |
![]() |
Connect to a database |
![]() |
Create a database |
![]() |
Edit database connection parameters |
![]() |
Make work with a database faster |
![]() |
Design a visual database structure |
![]() |
View an ER diagram |
![]() |
Create a database copy |
![]() |
Document a database |
![]() |
Save metadata reports to file |
![]() |
Log database changes |
![]() |
Get an SQL dump |
![]() |
Synchronize two databases |
![]() |
Work with Database Objects |
![]() |
Group objects |
![]() |
Find objects |
![]() |
View dependecies |
![]() |
Get an object DDL |
![]() |
Work with Data |
![]() |
View tables with many records |
![]() |
Set data filter |
![]() |
Sort and group data |
![]() |
Export/import data |
![]() |
Export data as SQL script |
![]() |
Edit data of master-detail tables |
![]() |
Add image to table |
![]() |
Set data display format |
![]() |
Work with Queries and Scripts |
![]() |
Create SQL statements rapidly |
![]() |
Control a query productivity |
![]() |
Work with several queries at once |
![]() |
Save most frequently used queries |
![]() |
Execute queries with parameters |
![]() |
Export query results into file |
![]() |
Execute scripts |
![]() |
Execute a large SQL script |
![]() |
Make SQL script work faster |
![]() |
Customize work with query/script text |
![]() |
View executed queries and scripts |
![]() |
Work with Version Control |
![]() |
Enable version control |
![]() |
Create the repository for a database from scratch |
![]() |
Rollback to previous revision state |
![]() |
View database changes |
![]() |
View procedure changes |
![]() |
Create a simple report in report designer |
![]() |
Transfer program settings |
![]() |
Update SQL Manager |
![]() |
Report bugs and suggestions |
© 1999-2025 EMS Software Development