EDB PostgreSQL

PostgreSQL is EDB’s open source distribution of PostgreSQL, the high performance, reliable, flexible, and open source multi-model database platform.

Overview

Architecture

EDB PostgreSQL Architecture

Postgres Major Features

Postgres Major Features

POSTGRESQL is an open-source, full-featured relational database. It has been under open source license (the PostgreSQL License) since 1996. It has a similar technical heritage as Oracle, Microsoft SQL Server and IBM DB2, however, it strongly adheres to the ANSI SQL standard.

PostgreSQL supports several procedural languages. This allows a developer to write procedures and functions in PL/pgSQL, PL/Tcl, PL/Perl and PL/Python. A multitude of other language implementations are also available, such as PL/PHP, PL/V8, PL/Ruby, PL/Java, etc.

PostgreSQL’s design is highly extensible and provides for the addition of new programing languages, new data types, and new indexes. This allows for rapid innovation illustrated with the JSONB document model, the PostGIS geographic information system and EDB’s implementations of SPL, a native implementation of a new programming language that supports key capabilities of Oracle’s PL/SQL procedural language.

Multi-Model Data Management

Multi-Model Data Management

PostgreSQL supports relational, document oriented, and key-value pair based data models. The relational model is supported through a very high degree of ANSI SQL conformance; the document oriented data representation is supported through JSONB; key-value pair capabilities are provided through the HSTORE extension. Together with a rich range of other extensions, such as PostGIS, this creates a uniquely positioned platform to combine structured and unstructured data in one transactional, ACID-compliant context.

Comparing EDB PostgreSQL and EDB Advanced Server

Comparing EDB PostgreSQL and EDB Advanced Server

 

Feature Key: compatible with Oracle® 

Enterprise Security Features

 

 

Feature

 

PostgreSQL

EDB Postgres Advanced Server

Data Redaction 

 

Description: es

Password Profiles

 

Description: es

EDB SQL/Protect

 

Description: es

Session Tag Auditing

 

Description: es

Server Procedural Language Protection (EDB*Wrap)

 

Description: es

 

 

Enterprise Performance Features

 

 

Feature

 

PostgreSQL

EDB Postgres Advanced Server

Query Optimizer Hints

 

Description: es

SQL Session/System Wait Diagnostics

 

Description: es

 

 

Enterprise Developer Features

 

 

Feature

 

PostgreSQL

EDB Postgres Advanced Server

Autonomous Transactions

 

Description: es

Hierarchical Queries

 

Description: es

21 Pre-defined, Re-usable Function Packages

 

Description: es

Synonyms (Public and Private)

 

Description: es

Extended Functions and Operators

 

Description: es

Bulk Collect and Binds

 

Description: es

User Defined Object Types

 

Description: es

Nested Tables

 

Description: es

User Defined Exceptions

 

Description: es

User Defined Packages and Functions

 

Description: es

Associative Arrays

 

Description: es

VARRAYs

 

Description: es

edb_stmt_level_txn

 

Description: es

EDB*Plus

 

Description: es

ECPGPlus

 

Description: es

 

 

Enterprise DBA Features

 

 

Feature

 

PostgreSQL

EDB Postgres Advanced Server

Resource Management

 

Description: es

EDB*Loader

 

Description: es

Extended Catalog Views

 

Description: es

 

 

Database Compatibility for Oracle

 

 

Feature

 

PostgreSQL

EDB Postgres Advanced Server

Free Migration Assessment Portal in the Cloud 

 

Description: es

Data Type Compatibility

 

Description: es

Automated Migration of Schema, Data, and Objects

 

Description: es

PL/SQL Support in Stored Procedures and Triggers

 

Description: es

PL/SQL Debugger

 

Description: es

EDB*OCI

 

Description: es

Pro*C Support

 

Description: es

Bulk Data Loader

 

Description: es

Interactive and Batch Command-Line Processor

 

Description: es

Replication with Oracle (*uses EDB Postgres Replication Server)

 

Description: es

Resources