Skip to content

PostgreSQL software and community

Jump to bottom
Jennifer Scheuerell edited this page Mar 2, 2020 · 1 revision

PostgreSQL software

From postgresql.org/docs

PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.

PostgreSQL is an open-source descendant of this original Berkeley code. It supports a large part of the SQL standard and offers many modern features:

complex queries
foreign keys
triggers
updatable views
transactional integrity
multiversion concurrency control

Also, PostgreSQL can be extended by the user in many ways, for example by adding new

data types
functions
operators
aggregate functions
index methods
procedural languages

And because of the liberal license, PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic.

PostgreSQL community

From postgresql.com/community

PostgreSQL is well-supported by its active community. There are more than a dozen mailing lists available, categorized into topics like:

  • Announcements

  • PostgreSQL development

  • General PostgreSQL Support

  • Jobs

and more. We also have many local PostgreSQL User Groups all over the world, and there is also an active IRC & Slack community.

There are also links to international sites that contain PostgreSQL information in various languages.

People in the PostgreSQL community also contribute to:

  • Planet PostgreSQL, an aggregator of blogs covering many topics around PostgreSQL

  • PostgreSQL Wiki, our wiki, hosting user generated content as well as information for how to contribute code to PostgreSQL

Clone this wiki locally