Free software

EMS SQL Manager for PostgreSQL is a powerful utility for PostgreSQL Database Server administration and design. PostgreSQL Manager works with any PostgreSQL versions up to 8.2 and supports all of the latest PostgreSQL highlights including tablespaces, argument names in functions, and a lot of others.

EMS SQL Manager for PostgreSQL 4.3.0.4 offers plenty of powerful tools for experienced PC users such as Visual Database Developer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. PostgreSQL Manager has a new state-of-the-art graphical PC user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Main features:

• Managing reports the same path as if they were database objects: accessing reports directly through DB Explorer tree
• A lot of visual customization options
• Clustering tables
• Managing table/view rules
• Full maintenance of PostgreSQL up to version 8.2
• Easy management of all PostgreSQL objects
• Ability to produce diagrams based on queries
• Saving as pic or printing database diagram
• Multiple SQL editors with code completion, syntax feature and code folding
• SSL connexions support
• Changing column types
• Connecting via home port forwarding through the SSH tunnel
• Analyzing tables
• Other beneficial tools to generate your work with PostgreSQL Server as simple as it can be
• Exporting info to most famous formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc
• Registering selected databases to work with
• Support of UTF8 data
• Improved database explorer for simple management of all PostgreSQL objects
• Creating domains based on other domains
• Viewing and changing object permissions to database roles in object editors
• Table and card views to see info the path you like
• Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax
• Master-detail view to work with two linked tables at the same time
• SQL Formatter (Available from SQL Editor context menu)
• Projects to work with the selected database objects only
• Working with various selected objects at a time
• Multiple user-defined tabs for any tree node to access it in one-click
• Impressive info export and import capabilities
• Report developer for building powerful reports visually
• Easy-to-use wizards performing PostgreSQL support tasks
• Vacuuming tables
• Duplicating all database objects
• New Produce Report Wizard allows you to produce easy reports in a few clicks
• SQL Monitor
• Reindexing tables
• Copying metadata and info from one database to another as a whole or partially
• Powerful visual options module
• Plenty of beneficial tools such as info grouping, fast searching and filtering
• Grant manager displaying all database object grants in the form of a grid
• Support of dollar-quoted strings
• Server Log Viewer
• Customizable toolbars for all program windows
• Wizard to download and upload files from/to PostgreSQL server
• Navigation bars with ardent actions in most of the windows
• Large script execution (SQL script editor)
• Managing views, functions, sequences
• Report developer with clear in use report construction wizard
• Extracting metadata into content files or SQL script editor
• Creating/dropping databases and schemas
• Several pages in one diagram to divide diagram into different subject areas
• Ability to copy and paste selected records
• Reverse engineering
• Support of CONNECT permission for databases and USAGE permission for sequences
• Ability to add comments to diagram
• Office 11 and Windows XP visual schemes support
• Managing tables and all their subobjects: areas, indices, triggers, rules, checks and alien keys
• Favorite Queries (Save and use your frequently used queries easily)
• Renaming all database objects
• Ability to view query plan as diagram
• Viewing dependencies between database objects
• Access to PostgreSQL Server through HTTP protocol
• Excellent visual and content tools for query building
• Exporting info to SQL script as INSERT statement
• Importing info from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
• Two diagram notations (IDEF1x and IE)
• Rapid database management and navigation
• Ability to produce, edit and drop tables and table areas, set links between tables visually
• Fully customizable program interface
• Effective safety management
• Powerful PL/pgSQL function debugger
• Support of argument names in functions
• Managing types, aggregates, operators, languages
• Advanced info manipulation tools
• New state-of-the-art graphical PC user interface
• Useful diagram navigation tool
• Support of FILLFACTOR factor for tables and indices
• New Windows Toolbar to switch between windows easily, like in Windows Task Bar
• Database statistics module to view multiple statistic details on database objects
• Grouping/Ungrouping registered databases by host name
• Powerful print metadata module for creating customizable metadata reports
• To-do list
• Localizable program interface
• And other beneficial features
• Powerful visual database designer
• External utility manager
• Creating indexes concurrently
• Powerful PC user and group manager for administering PC users and privileges
• Wizards for copying info from/to file on server
• New well-described Wizard System
• Powerful BLOB viewer/editor with various types of viewing BLOB data
• Multiple host/database connections
• HTML report wizard to produce a detailed HTML report about your database quickly
• Keyboard templates
• Ability to save all program settings

Requirements:
- 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
- 64 MB RAM or more; 128 MB or more recommended
- 50MB of accessible HD space for program installation
- Super VGA (800×600) or higher-resolution movie adapter and monitor; Super VGA (1024×768) or higher-resolution recommended
- Microsoft Mouse or compatible pointing device
- Possibility to connect to any home or remote PostgreSQL server

Related posts

• XlsToSql 1.0 (0)
• YukonDev SQL Editor 1.8.16.43 (0)
• Recovery for Exchange Server 4.0.0813 (0)
• ESF Database Convert 5.7.25 (0)
• Super Flexible File Synchronizer 4.00 Build 47 (0)

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.