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. https://www.postgresql.org/docs/
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.
admin
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. https://www.postgresql.org/docs/
PostgreSQL supports a large part of the SQL standard and offers many modern features:
Also, PostgreSQL can be extended by the user in many ways, for example by adding new
Being open-source, PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic.