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:
* Add materialized views
* Make simple views auto-updatable
* Add many features for the JSON data type, including operators and functions to extract elements from JSON values
* Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls
* Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables
* Add a Postgres foreign data wrapper to allow access to other Postgres servers
* Add support for event triggers
* Add optional ability to checksum data pages and report corruption
* Prevent non-key-field row updates from blocking foreign key checks
* Greatly reduce System V shared memory requirements

PostgreSQLInformation

Version
9.3.0
Date
09.10.13
License
Free
Language
English
File Size
50.96MB
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
CASE Studio 2 Icon
Create ER diagrams for various databases, generate SQL scripts, HTML reports
Paid
SQL Prompt Icon
Intelligent code completion and layout for MS SQL Server
Paid
Crystal Reports Server XI Icon
Transforming data into actionable information accessible anytime, anywhere
Trial
xSQL Script Executor Icon
Execute multiple T-SQL scripts against multiple SQL Server, DB2, and MySQL databases.
Free
AppGini Icon
Generates multi-user PHP applications for MySQL without programming skills.
Trial
SQL Dumper Icon
Allows dumping a SQL Server Database to a text file
Free
Navicat for MySQL Icon
Create and browse MySQL databases, run SQL queries, or build reports.
Demo
More