You are here

PostgreSQL

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.

PostgreSQL features include:

  • Runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows
  • Referential integrity
  • Fully ACID compliant
  • Supports 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
  • Supports storage of binary large objects, including pictures, sounds, or video
  • Supports partitioning
  • Supports tablespaces
  • Schemas
  • Online backup
  • Point-in-time recovery
  • Master-Slave replication
  • Native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others
  • GIS indexing
  • Distributed database

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer