Knowledgebase: MySQL & PostgreSQL
What is PostgreSQL?
Posted by Diego Cousinet on 21 February 2011 11:50 AM

PostgreSQL is a feature-rich open-source SQL database, in fact, its slogan is "The world's most advanced open source database".

It complies to the ANSI-SQL 92/99 standard and supports advanced features such as transactions, stored procedures, database inheritance and nested queries.



"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 runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. 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. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, andexceptional documentation."
(31 vote(s))
Not helpful

Comments (0)