Online Documentation for SQL Management Studio for PostgreSQL

Using Desktop Panel


Desktop Panel is the main working area of SQL Management Studio for PostgreSQL. The content of the Desktop Panel scratch changes dynamically according to the current selection in the Navigation bar of the main toolbar.

 

Getting Started - Desktop Panel

 

Using the Desktop Panel items you can:

 

DBManagement launch the all-in Database management program (SQL Manager for PostgreSQL) and run basic PostgreSQL services:

  • Analyze Tables (with or without a template);
  • Vacuum Tables (with or without a template);
  • Reindex (with or without a template);

 

DataManipulation launch integrated Data manipulation utilities:

  • Data Export for PostgreSQL (with or without a template, GUI or console version);
  • Data Import for PostgreSQL (with or without a template, GUI or console version);
  • Data Pump for PostgreSQL (with or without a template, GUI or console version);
  • Data Generator for PostgreSQL (with or without a template, GUI or console version);
  • SQL Script for PostgreSQL (with or without a template, GUI or console version);

 

DataAnalysis launch utilities implemented for Data analysis:

  • Data Comparer for PostgreSQL (with or without a template, GUI or console version);
  • DB Comparer for PostgreSQL (with or without a project file, GUI or console version);
  • DB Extract for PostgreSQL (with or without a template, GUI or console version);
  • SQL Query for PostgreSQL;

 

TemplateManagement manage templates for each of the integrated tools and services;

 

CustomTasks manage miscellaneous tasks;

 

TaskScheduler manage scheduled tasks;

 

Logs manage task logs;

 

InternetResources use available Internet resources:

  • visit SQL Studio Home Page;
  • browse SQL Studio pages dedicated to Frequently Asked Questions;
  • browse online documentation concerning SQL Studio components;
  • visit PostgreSQL related resources;

 

StudioDirect use the SQL Studio Direct feature;

 

Support get technical support online.

 

Hint: To activate/deactivate brief descriptions displayed for each tool on the Desktop Panel, you can use the View | Show Tool Descriptions item of the main menu.