Features of PostgreSQL
PostgreSQL runs on all operating systems, Like Linux, UNIX, MAC OS and Windows and It supports text, images, sounds, and video, and includes programming interfaces for C / C++, Java, Perl, Python, Ruby, and Open Database Connectivity (ODBC).
PostgreSQL supports a big part of the SQL standard and provides many features mentioned below:
- Complex SQL queries
- SQL Sub-selects
- Foreign keys
- Trigger
- Views
- Transactions
- Multiversion concurrency control (MVCC)
- Streaming Replication (as of 9.0)
- Hot Standby (as of 9.0)
- Asynchronous replication
- Tablespaces
PostgreSQL Tutorial
PostgreSQL is one of the most advanced general-purpose Relational database management systems (RDMS). It is open-source software, which means the source code is available under the PostgreSQL license. Anyone with the right skills is free to use, modify, and distribute PostgreSQL in any form. It supports both relational as well as Non-Relational JSON Queries.
In this PostgreSQL tutorial you’ll learn the basic data types(Boolean, char, text, time, int etc.), Querying and Filtering techniques like select, where, in, order by, etc. managing and modifying the tables in PostgreSQL. We’ll cover all the basic to advance concepts of PostgreSQL in this tutorial.
What is PostgreSQL?
PostgreSQL is an advanced and open-source relational database system and is used as a database for many web applications, mobile and analytics applications. It supports both SQL (relational) and JSON (non-relational) querying and It is a stable database supported by more than 20 years of development by the open-source community.
Table of Content
|