Online Documentation for SQL Management Studio for PostgreSQL

Using services


SQL Studio integrated features provide easy way to run all native PostgreSQL services which are intended for database maintenance. The following services and server tools are available:

 

To run a service, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template, and run the wizard with this template.

 

To manage configuration files (templates), use the corresponding Manage templates link. In this case you will be redirected to the Template Management section of SQL Studio.

 

Database Management - Services

 

 

Analyze Tables

Collects statistics about the contents of database tables.

 

Vacuum Tables

Reclaims storage occupied by deleted tuples.

 

Reindex

Rebuilds corrupted indexes.

 

Backup Database

Creates backup copies of your PostgreSQL databases.

 

Restore Database

Restores PostgreSQL databases from previously created backups.