PostgreSQL Icon

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQLOverview

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.

NEW

# Major enhancements in PostgreSQL 9.4 include:

- Add jsonb, a more capable and efficient data type for storing JSON data
- Add new SQL command ALTER SYSTEM for changing postgresql.conf configuration file entries
- Reduce lock strength for some ALTER TABLE commands
- Allow materialized views to be refreshed without blocking concurrent reads
- Add support for logical decoding of WAL data, to allow database changes to be streamed out in a customizable format
- Allow background worker processes to be dynamically registered, started and terminated

PostgreSQLInformation

Version
9.4.0
Date
12.22.14
License
Free
Language
English
File Size
55.97MB
Category
SubCategory
Operating Systems
Windows (All Versions)
System Requirements
No additional system requirements.
MySQL Query Browser Icon
The easiest visual tool for creating, executing, and optimizing SQL queries
Free
Statement Tracer for Oracle Icon
A free solution for debugging programs interfacing with the Oracle RDBMS.
Free
CASE Studio 2 Icon
Create ER diagrams for various databases, generate SQL scripts, HTML reports
Paid
Access Database Engine 2010 Beta Icon
Read data from and write data to Office 2010 Beta system files
Free
ACCDB Password Icon
Recover passwords in Microsoft Access (accdb, accde, accdm) databases.
Demo
xSQL Script Executor Icon
Execute multiple T-SQL scripts against multiple SQL Server, DB2, and MySQL databases.
Free
TOAD for Oracle Icon
Tool for Oracle Application Developers.
Trial
Snail Mail Icon
Envelope printing application for use with the Mac OS X Address Book database.
Free
More