Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

PostgreSQL Features

What are the features of PostgreSQL?

Database Features

  • Storage
  • Availability
  • Stability
  • Scalability
  • Security
  • Data Manipulation
  • Query Language

Support

  • Text Search
  • Data Types
  • Operating Systems

Security

  • Database Locking
  • Access Control

Performance

  • Data Concurrency

Management

  • Data Schema
  • Query Language

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5
PostgreSQL Categories on G2

Filter for Features

Database Features

Storage

As reported in 436 PostgreSQL reviews.
89%
(Based on 436 reviews)

Availability

This feature was mentioned in 441 PostgreSQL reviews.
90%
(Based on 441 reviews)

Stability

As reported in 444 PostgreSQL reviews.
90%
(Based on 444 reviews)

Scalability

426 reviewers of PostgreSQL have provided feedback on this feature.
86%
(Based on 426 reviews)

Security

This feature was mentioned in 415 PostgreSQL reviews.
87%
(Based on 415 reviews)

Data ManipulationView full feature definition

See feature definition
This feature was mentioned in 429 PostgreSQL reviews.
88%
(Based on 429 reviews)

Query Language

436 reviewers of PostgreSQL have provided feedback on this feature.
90%
(Based on 436 reviews)

Support

Text Search

Provides support for international character sets and full text search. 89 reviewers of PostgreSQL have provided feedback on this feature.
85%
(Based on 89 reviews)

Data Types

As reported in 100 PostgreSQL reviews. Supports multiple data types like primitive, structured, document etc.
92%
(Based on 100 reviews)

Languages

Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. 87 reviewers of PostgreSQL have provided feedback on this feature.
92%
(Based on 87 reviews)

Operating Systems

Based on 89 PostgreSQL reviews. Available on multiple operating systems like Linux, Windows, MacOS etc.
91%
(Based on 89 reviews)

Security

Database Locking

As reported in 90 PostgreSQL reviews. Prevents other users and applications from accessing data while it is being updated to avoid data loss or update.
87%
(Based on 90 reviews)

Access Control

Based on 92 PostgreSQL reviews. Allows permissions to be granted or revoked in the database, schema or table levels.
89%
(Based on 92 reviews)

Encryption

Built-in native encryption with enterprise key management. This feature was mentioned in 84 PostgreSQL reviews.
86%
(Based on 84 reviews)

Authentication

Based on 88 PostgreSQL reviews. Provides multi-factor authentication with certificates.
89%
(Based on 88 reviews)

Performance

Disaster Recovery

Based on 83 PostgreSQL reviews. Provides data recovery functionality to protect and restore data in a database.
86%
(Based on 83 reviews)

Data Concurrency

As reported in 89 PostgreSQL reviews. Allows multi-version concurrency control.
88%
(Based on 89 reviews)

Workload Management

Based on 86 PostgreSQL reviews. Handles workloads, from single machines to data warehouses or web services with many concurrent users.
86%
(Based on 86 reviews)

Advanced Indexing

Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. This feature was mentioned in 89 PostgreSQL reviews.
88%
(Based on 89 reviews)

Query Optimizer

Helps interpret SQL queries and determine the fastest method of execution. 86 reviewers of PostgreSQL have provided feedback on this feature.
86%
(Based on 86 reviews)

Management

Data Schema

As reported in 97 PostgreSQL reviews. Data is organized as a set of tables with columns and rows like a table structure.
92%
(Based on 97 reviews)

Query Language

Based on 95 PostgreSQL reviews. Allows users to create, update and retrieve data in a database.
92%
(Based on 95 reviews)

ACID - Complaint

Based on 84 PostgreSQL reviews. Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.
90%
(Based on 84 reviews)

Data Replication

As reported in 88 PostgreSQL reviews. Provides log-based or/and trigger-based replication.
89%
(Based on 88 reviews)