Free postgresql gui software for windows

EMS SQL Manager for PostgreSQL Lite 4.6.0.7 proves itself to be a helpful tool for PostgreSQL database administration and development. It works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, PostgreSQL index key sorting order, arrays of composite types, and others.

SQL Manager for PostgreSQL offers plenty of powerful database tools such as Visual Database Designer to create PostgreSQL database in few clicks, Visual Query Builder to build complicated PostgreSQL queries, powerful BLOB editor and many more useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Major Features:

1. Support of UTF8 data
2. Excellent visual and text tools for query building
3. New state-of-the-art graphical user interface
4. Rapid database management and navigation
5. Advanced data manipulation tools
6. Full support of PostgreSQL up to version 8.4
7. Improved database explorer for easy management of all PostgreSQL objects
8. Effective security management
9. Impressive data export and import capabilities
10. Powerful visual database designer
11. Easy-to-use wizards performing PostgreSQL maintenance tasks
12. Connecting via local port forwarding through the SSH tunnel
13. Access to PostgreSQL Server through HTTP protocol
14. Office 11 and Windows XP visual schemes support
    

DreamCoder for PostgreSQL Free Edition 1.5 is the award-winning, powerful tool that allows you to easily. It is a powerful Integrated Development Environment (IDE) for PostgreSQL Databases. With the intuitive DreamCoder's GUI you will increase your code quality and reduce the development process time.

DreamCoder for PostgreSQL works with all PostgreSQL Server versions from 8.0 to 8.1.4. DreamCoder for PostgreSQL enables you to easily build and execute queries, build and execute scripts, compile PL/pgSQL code, create and modify database objects, import and export data, enable user session and database monitor and more.
DreamCoder for PostgreSQL offers powerful visual tools for increase your productivity like a SQL editor, PL/pgSQL editor, master detail table browser, database structure synchronization parameter manager, SQL formatter, query builder, SQL history, session monitor and more.

Major Features:

1. Principal features

• Powerful SQL Editor
• Powerful PL/pgSQL
• Advanced Query Builder
• SQL OutPut
• SQL History
• SQL Code formatter
• Master detail Table browser
• Parameter Manager
• Database Session monitor
• Project Manager
• Template List
• Compare User Objects
• Database Export Manager
• SQL Autocomplete
• SQL Highlighter
• Connection manager
• Workgroup development
• Rename object
• Truncate table
• Record count option
• Object Navigator
  

2. Viewing PostgreSQL objects

• View tables
• View Views
• View Sequences
• View Index
• View Functions
• View Triggers
• View Domains
• View Operators
• View Aggregates
• View Tablespaces
• View Languages
• View Users

3. Synchronization

• Database Structure Synchronization
  

4. Data Grid Manipulation

• Advanced grid options including copy and paste records from MS Excel , delete selected records, customize columns, multiple export options and customization.
• Data Grouping
• Data Filtering
• Automatic Sorting
• Filter Builder
• Summary Data Groups (Sum,Min,Max,Count,Average)

5. Powerful data manipulation tools

• Export data to 14 popular formats.
• Import data from 7 popular formats.
• Export data to SQL script as INSERT statement.

6. Fully customizable program interface

• Program options: windows, fonts, grid colors, etc.
• Editors: custom colors, fonts etc.
• Toolbars for all program windows
• Powerful Visual Options Module
• Possibility of saving all the program settings
• Localizable program interface

Enhancements:

• Knowledge base integrated
• PostgreSQL 8.2 support
• Enhanced Query builder
• Several minor bugs are fixed.

Requirements:

• DreamCoder for PostgreSQL will run on Windows 95, 98, NT4, 2000, 2003 and XP.
• The supported PostgreSQL Server versions 8 or higher.