Author Avatar



Share post:

PostgreSQL is an open-source object-relational database system. In many aspects, it is similar to other RDBMS systems. But it is quite different too in many aspects. It has been used in many critical systems and being open-sourced, has been adapted, enhanced, and improvised by major industry players. Depending on requirements, it is available to install on the machine as well as to use directly in the cloud. PostgreSQL can be installed on all major operating systems – Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

In subsequent pages, we will go through the features and usage of the PostgreSQL database. We will learn how to install, start, stop and perform other operations on the database. Further, we will learn how to perform advanced operations like backup, restore, and setting up replication, etc.

PostgreSQL official documentation is here for various versions.

PostgreSQL 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

Being open-source, PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic.

Installing PostgreSQL

Leave a Comment

Your email address will not be published. Required fields are marked *