DreamCoder for PostgreSQL
View demo | Download | Get quote

Feature List

Supports all versions of database server (8.0,8.1,8.2,8.3,8.4)
• Supports the latest PostgreSQL 8.3 version
Data Handling
• Add, view, edit, search, group, sort and filter data
• Ability to copy and paste data directly from Excel
• Ability to delete selected records
• Able to export data into SQL inserts
• Able to create master detail relationships between an unlimited number of tables
• Utility to manipulate LOV
• Advanced filter data constructor
Advanced visaul query builder and text
• Advanced SQL editor with autocomplete, syntax highlighting, code folding, objetcs description, code proposal and parameters management
• Advanced query builder to build SQL's - no previous knowledge required
• SQL Code Formatter
• Run scripts
• Auto replacement of parameters
Options for exporting and importing data
• Utility to export data from database
• Utility to transfer data from database
• Utility to export in multiple formats (MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF)
• Utility to import multiple data formats (MS Excel, MS Access, DBF, XML, ODF, TXT and CSV)
• Advanced options for export and import at data grid level
• Utility to import data from excel
• Simple data export data to a table
Advanced options for synchronizing the database
• Utility to synchronize two database schemas
• Utility to synchronize data of two databases
Database Monitoring
• System Monitor
• Built and executed queries History
IDE customization options
• Complete options for modifying IDE behavior
• Complete options for modifying SQL editor behavior
• Complete options for modifying data grid behavior