PostgreSQL Background
PostgreSQL Icon

PostgreSQL

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

2.2K
Downloads
4.0
2 Ratings
All Versions
2.2K
Total Downloads
0
Downloads Last Week
Current Version
621
Total Downloads
0
Downloads Last Week
Downloads Last 10 Weeks
All Versions
4.0
2 Ratings
5
4
3
2
1
Current Version
-
0 Ratings
5
4
3
2
1

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

PostgreSQLTech Specs

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.

AppsSelected For You

DbVisualizer Icon
Connect to different databases through JDBC drivers.
Free
Crystal Reports Server XI Icon
Transforming data into actionable information accessible anytime, anywhere
Allegro CL Icon
Persistency built in, not a database add-on.
Free
FastReport.Net Icon
Powerful and flexible net reports generator with visual report designer
phpMyAdmin Icon
Manage MySQL databases via the Web.
Free
PostgreSQL Icon
PostgreSQL is a powerful, open source object-relational database system.
Free
SQL Server 2008 R2 Express Icon
SQL Server 2008 Express Edition is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2008.
Free
dotConnect for MySQL Icon
Develop MySQL database applications using ADO.NET technology.