What is PostgreSQL

PostgreSQL (pronounced as /ˈpoʊstɡrɛs ˌkjuː ˈɛl/) is a multi-purpose object-relational database management system.  PostgreSQL is sometimes referred to as Postgres.  The PostgreSQL database first started as POSTGRES in 1986 at the University of California at Berkeley.  In 1996, the project was renamed to PostgreSQL to reflect its support for SQL.  PostgreSQL has a strong reputation for its proven architecture, reliability, data integrity, robust feature set, and extensibility.

Why PostgreSQL

PostgreSQL is an ACID compliant object-relational data which gives it some advantages over other open source SQL databases like MySQL.  An object-relational database has support for user-defined objects and their related data types, functions, operators, domains and indexes. This makes PostgreSQL extremely flexible and robust.  PostgreSQL is also well supported through a strong open source community and commercial support options.

Who uses PostgreSQL

Many companies, individuals, schools, and other institutions use PostgreSQL.   Some of the companies using PostgreSQL include BMW, Nokia, Bloomberg, Cloudera, Reddit, and Goldman Sachs.

Next: Connecting to PostgreSQL

Was this post helpful?

Helpful Links

Common SQL mistakes and how to avoid them.