EMS SQL Manager Lite for PostgreSQL is a light and easy-to-use freeware graphical tool for PostgreSQL administration. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the latest PostgreSQL features including tablespaces, named arguments in functions and so on.

EMS SQL Manager 2007 Lite for PostgreSQL is a database manager that helps you administrate PostgreSQL.

EMS SQL Manager 2007 has minimal required set of instruments for those users who are new to PostgreSQL server and need only its basic functionality.

Here are some key features of "EMS SQL Manager 2007 Lite for PostgreSQL":

· Full support of PostgreSQL up to version 8.2
· Support of FILLFACTOR parameter for tables and indices
· Creating indexes concurrently
· Creating domains based on other domains
· Support of CONNECT permission for databases and USAGE permission for sequences
· Changing column types
· Support of argument names in functions
· Support of dollar-quoted strings
· Support of UTF8 data
· New state-of-the-art graphical user interface
· Office 11 and Windows XP visual schemes support
· New well-described Wizard System
· Improved database explorer for easy management of all PostgreSQL objects
· New Windows Toolbar to switch between windows easily, like in Windows Task Bar
· Navigation bars with hot actions in most of the windows
· Ability to save all program settings
· Customizable toolbars for all program windows
· Fully customizable program interface
· Powerful visual options module
· Localizable program interface
· Rapid database management and navigation
· Multiple host/database connections
· SSL connections support
· Registering selected databases to work with
· Projects to work with the selected database objects only
· Access to PostgreSQL Server through HTTP protocol
· Connecting via local port forwarding through the SSH tunnel
· Multiple user-defined tabs for any tree node to access it in one-click
· Working with multiple selected objects at a time
· Grouping/Ungrouping registered databases by host name
· Easy management of all PostgreSQL objects
· Creating/dropping databases and schemas
· Managing tables and all their subobjects: fields, indices, triggers, rules, checks and foreign keys
· Managing views, functions, sequences
· Managing types, aggregates, operators, languages
· Managing table/view rules
· Duplicating all database objects
· Renaming all database objects
· Viewing dependencies between database objects
· Advanced data manipulation tools
· Plenty of useful tools such as data grouping, fast searching and filtering
· Effective security management
· Powerful user and group manager for administering users and privileges
· Grant manager displaying all database object grants in the form of a grid
· Viewing and changing object permissions to database roles in object editors
· Excellent visual and text tools for query building
· Multiple SQL editors with code completion, syntax highlight and code folding
· Large script execution (SQL script editor)
· Favorite Queries (Save and use your frequently used queries easily)
· Other useful tools to make your work with PostgreSQL Server as easy as it can be
· Extracting metadata into text files or SQL script editor
· SQL Monitor
· And other useful features
· Keyboard templates
· To-do list
· External tool manager

Requirements:

· 300-megahertz (MHz) or higher Pentium II-compatible processor
· Super VGA (1024x768) or higher-resolution recommended
· 64 MB RAM or more; 128 MB or more recommended
· 50MB of available HD space for program installation
· Microsoft Mouse or compatible pointing device
· Possibility to connect to any local or remote PostgreSQL server

What's New in This Release: [ read full changelog ]

· Database Registration Info dialog.
· Most of the options from the Grid | Data Options section of the Environment Options dialog can now be specified individually for each of the registered databases in the Database Registration Info dialog. The values specified in the Grid | Data Options section will be applied as default settings for newly registered databases.
· The "Schema-organized database tree" option is added. Disabling this option results in creating the object tree without schema division.
· Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
· Query Builder.
· When a table is added into a query, its foreign key connections to other tables participating in this query are reflected by JOIN statements.
· In some cases renaming a table and moving to the SQL tab resulted in the “Cannot bind JOIN expression” error. Fixed now.
· Function Editor
· The results of functions returning cursor can now be viewed.
· If the DOUBLE PRECISION argument value was set to “0�...