EMS logo

Produits

SQL Manager for PostgreSQL

Notre statut de partenariat

MySQL Gold Certified Partner
Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for PostgreSQL

Documentation en ligne


Welcome to SQL Manager for PostgreSQL!
What's new?
System requirements
Feature Matrix
Installation
Registration
License Agreement
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
Managing projects
Searching within the tree
SQL Assistant
Configuring Database Explorer
Managing Favorite queries
Database Management
Register Host wizard
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
Common options
Display options
Default directories
Logs
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 fields
Table Editor
Using Navigation bar and Toolbar
Managing fields
Changing fields order
Managing foreign keys
Managing checks
Managing indexes
Managing triggers
Managing rules
Working with table data
Table properties
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
Fields
Field Editor
Setting field name and type
Setting field size and precision
Setting field flags
Setting field statistics
Setting default value and description
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
Views
View Editor
Using Navigation bar and Toolbar
Creating/editing view
Managing fields
Managing rules
Managing triggers
Working with data
Functions
Function Editor
Using Navigation bar and Toolbar
Creating/editing function
Executing functions
Specifying input parameters
Function Debugger
Using Navigation bar and Toolbar
Debugging function
Browsing debug information
Domains
Domain Editor
Using Navigation bar and Toolbar
Creating/editing domain
Managing domain checks
Rules
Rule Editor
Using Navigation bar and Toolbar
Creating/editing rule
Triggers
Trigger Editor
Using Navigation bar and Toolbar
Editing trigger definition
Sequences
Sequence Editor
Using Navigation bar and Toolbar
Creating/editing sequence
Base Types
Base Type Editor
Using Navigation bar and Toolbar
Creating/editing base type
Composite Types
Composite Type Editor
Using Navigation bar and Toolbar
Creating/editing composite type
Enumerated Types
ENUM Type Editor
Using Navigation bar and Toolbar
Creating/editing ENUM type
Aggregates
Aggregate Editor
Using Navigation bar and Toolbar
Creating/editing aggregate
Operators
Operator Editor
Using Navigation bar and Toolbar
Creating/editing operator
Collations
Collation Editor
Using Navigation bar and Toolbar
Creating/editing collation
Non-schema Objects
Tablespaces
Tablespace Editor
Using Navigation bar and Toolbar
Creating/editing tablespace
Languages
Language Editor
Using Navigation bar and Toolbar
Creating/editing language
Local Scripts
Shared scripts
TFS
CVS
VSS
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
SQL Editor
Using Navigation bar and Toolbar
Working with SQL Editor area
Using the context menu
Viewing query plan
Adding objects to query
Using object links
Executing queries
Viewing query logs
Favorites editor
Merging queries
Visual Query Builder
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 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
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 fields for export
Adjusting data formats
Setting header and footer
Setting format-specific options
Excel options
Data format
Fields
Options
Styles
Extensions
Hyperlinks
Notes
Charts
Cells
Merged Cells
Advanced
Access options
Word / RTF options
Base Styles
Strip Styles
HTML options
Preview
Basic
Multi-file
Advanced
PDF options
TXT options
CSV options
XML options
MS Excel 2007 / ODS options
MS Word 2007 / ODT options
Setting common export options
Exporting data
Import Data Wizard
Selecting source file name and format
Selecting data source
Setting fields correspondence
Excel
Access, DBF, XML Datapacket
TXT
CSV
HTML
XML Generic
MS Excel/Word 2007, ODF
Adjusting data formats
Setting advanced field formats
Setting import mode
Customizing common options
Importing data
Export as SQL Script
Selecting destination DBMS
Setting destination file name
Setting BLOB options
Selecting fields to export
Editing table definition
Setting export options
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
Database Tools
Common DB Tools
Dependency Tree
Using Navigation bar and Toolbar
Viewing dependency tree
Visual Database Designer
Using Navigation bar and Toolbars
Using Diagram Navigator and DB Objects pane
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
SQL Script Editor
Using Navigation bar and Toolbar
Working with SQL Script editor area
Using Script Explorer
Script execution
Extract Database Wizard
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
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
SQL Monitor
Using Navigation bar and Toolbar
Working with SQL Monitor
Search in Metadata
Using Navigation bar and Toolbar
Setting search conditions
Viewing search results
Specific DB Tools
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
Diagram view
Browsing Object Statistics
Browsing Field Statistics
Browsing Database Statistics
Saving/loading statistics
Statistics Collector options
Copy Database Wizard
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
Backup Database
Selecting host
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
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
Compare Databases Wizard
Selecting source database
Selecting target database
Selecting type of the syncrhonization script
Defining options for destination script
Performing operation
Instance Manager
Using Navigation and Toolbar Bar
Extensions
Using Navigation and Toolbar Bar
Install/Update Extensions
Server Tools
Database 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
PostgreSQL server maintenance
Server Status
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
Personalization
SQL Manager Options
Environment Options
Preferences
Full mode activation
Confirmations
Windows
Tools
Timeouts
DB Explorer
Object Editors
SQL Editor
SQL Monitor
SQL Script
Query Builder
Style & Color Palette
Visual 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
Highlight
Quick Code
SQL Formatter
SQL Words
Key Mapping
Spell Checking
Find Option
Visual Options
Bars and menus
Trees and lists
Edit controls
Check boxes
Buttons
Page controls
Group boxes
Splitters
Navigation bar
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
External Tools
External Tools dialog
External Tool Info editor
Appendix
Program interface
Viewing object DDL structure
Editing object description
Browsing object dependencies
Setting object permissions
Changing Metadata window
Tip of the Day
Find Text dialog
Replace Text dialog
Host Login dialog
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 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

© 2011 EMS Database Management Solutions