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 include:
- Allow queries to retrieve data only from indexes, avoiding heap access (index-only scans)
- Allow the planner to generate custom plans for specific parameter values even when using prepared statements
- Improve the planner's ability to use nested loops with inner index scans
- Allow streaming replication slaves to forward data to other slaves (cascading replication)
- Allow pg_basebackup to make base backups from standby servers
- Add a pg_receivexlog tool to archive WAL file changes as they are written
- Add the SP-GiST (Space-Partitioned GiST) index access method
- Add support for range data types
- Add a JSON data type
- Add a security_barrier option for views
- Allow libpq connection strings to have the format of a URI
- Add a single-row processing mode to libpq for better handling of large result sets

PostgreSQLInformation

Version
9.2.0
Date
09.11.12
License
Free
Language
English
File Size
48.44MB
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
SQL Dumper Icon
Allows dumping a SQL Server Database to a text file
Free
Statement Tracer for Oracle Icon
A free solution for debugging programs interfacing with the Oracle RDBMS.
Free
One-Click SQL Restore Icon
This simple free tool restores full MS SQL server database backups.
Free
InterBase 2007 Server for Windows Icon
a relational database management system
Trial
FastReport.Net Icon
Powerful and flexible net reports generator with visual report designer
Trial
JumpStart Icon
Database initialization system for SQL Server.
Demo
Navicat for MySQL Icon
Create and browse MySQL databases, run SQL queries, or build reports.
Demo
More