Compare Postgres Databases

Compare Postgres Databases

PostgreSQL vs EDB Postgres™ Advanced Server

Features marked:
     are compatible with Oracle®
    Yes are security related

 
Feature
 
PostgreSQL EDB Postgres Advanced Server

General

  Includes all PostgreSQL features and updates, plus additional:
    - Security features
    - Performance features
    - Developer features
    - DBA features
    - Database compatibility with Oracle
 
Enterprise Security Features
 
Password Profiles ⊕ Yes   Yes
EDB SQL/Protect Yes   Yes
Session Tag Auditing Yes   Yes
Server Procedural Language Protection (EDB*Wrap) ⊕ Yes   Yes
 
Enterprise Performance Features
 
Scalable Partitioning   Yes
Partition By... Range
List
Range
List
Hash
Query Optimizer Hints ⊕   Yes
 
Enterprise Developer Features
 
Hierarchical Queries ⊕   Yes
21 pre-defined re-usable Function Packages   Yes
Synonyms (public and private) ⊕   Yes
Extended Functions and Operators ⊕   Yes
Explicit Commit/Rollback in Stored Proc. ⊕   Yes
Bulk Collect and Binds ⊕   Yes
User defined object types ⊕   Yes
Nested Tables ⊕   Yes
User Defined Exceptions ⊕   Yes
User defined packages and functions ⊕   Yes
Associative Arrays ⊕   Yes
VARRAYs ⊕   Yes
edb_stmt_level_txn ⊕   Yes
EDB*Plus ⊕   Yes
ECPGPlus   Yes
 
Enterprise DBA Features
 
Resource Management   Yes
Declarative Partitioning Syntax ⊕   Yes
EDB*Loader ⊕   Yes
SQL Session/System wait diagnostics ⊕   Yes
Extended Catalog Views ⊕   Yes
 
Database Compatibility for Oracle (also includes all features in table with the ⊕ symbol)
 
PL/SQL Support in Stored Procedures and Triggers ⊕   Yes
PL/SQL Debugger ⊕   Yes
EDB*OCI ⊕   Yes

  

Common Features

Go to: Different Features

 
Common Database Features
 
PostgreSQL Postgres Advanced Server
Compatible with EDB Postgres Tools: Postgres Enterprise Manager
Postgres Failover Manager
Postgres Backup & Recovery
Postgres Cloud Management
Postgres Replication Server
Postgres Data Adaptors
Postgres Migration Assessment Tool
Postgres Migration Toolkit
 
Postgres Enterprise Manager
Postgres Failover Manager
Postgres Backup & Recovery
Postgres Cloud Management
Postgres Replication Server
Postgres Data Adaptors
Postgres XA Connector
Postgres Migration Assessment Tool
Postgres Migration Toolkit
Full ACID Compliance Yes Yes
Multi-Version Concurrency Control (MVCC) Yes Yes
Strong conformance to ANSI-SQL:2008 standard Yes Yes
ANSI Constraints Yes Yes
Per-Column Collations Yes Yes
Column Trigger Yes Yes
Primary/Foreign keys support Yes Yes
GIN & GiST Indexes Yes Yes
Block Range Indexes (BRIN) Yes Yes
Function based Indexes Yes Yes
Composite Indexes Yes Yes
K-Nearest-Neighbor Indexes Yes Yes
Index-only Scans Yes Yes
Full Text Search Yes Yes
UPSERT (Update or Insert) Yes Yes
SQL Aggregates with CUBE, ROLLUP and GROUPING SETS Yes Yes
Triggers and Stored Procedures Yes Yes
Views Yes Yes Yes
Materialized Views Yes Yes Yes
View Security Barriers Yes Yes Yes
SQL USAGE privilege on types Yes Yes Yes
ANSI Standard SQL GRANT/REVOKE Yes Yes Yes
Column Level Permissions Yes Yes Yes
Row Level Security Yes Yes Yes ⊕
Group/Role Support Yes Yes Yes
SQL/MED Support Yes Yes
Programming language support for database Stored Procedures, Triggers and Functions. pgSQL
Java
C
C++
Perl
Python
Ruby
Javascript
Scheme
Tcl
PHP
pgSQL
Java
C
C++
Perl
Python
Ruby
Javascript
Scheme
Tcl
PHP
Application Client Library interface support libpq
JDBC
C
C++
Perl
Python
Ruby
Scheme
PHP
ODBC
.NET
Lisp
Qt
libpq
JDBC
C
C++
Perl
Python
Ruby
Scheme
PHP
ODBC
.NET
Lisp
Qt
Foreign Data Wrappers HDFS (Hadoop)
MongoDB
MySQL
PostgreSQL
HDFS (Hadoop)
MongoDB
MySQL
PostgreSQL
Unstructured Data Types XML
JSON
JSONB
Key-Value
XML
JSON
JSONB
Key-Value
Unlogged Tables Yes Yes
Range Data Types Yes Yes
Writeable Common Table Expressions Yes Yes
Window Functions Yes Yes
Rules Engine Yes Yes
In-place version upgrades Yes Yes
Streaming Replication & Hot Standby Yes Yes
Logical Decoding Yes Yes
Online Backup and Point In Time Recovery Yes Yes
Online Index Reorganization Yes Yes
Hot restart with pg_prewarm Yes Yes
pg_rewind Yes Yes
PostGIS spatial extensions support Yes Yes
Partitioning of Table and Indexes Yes Yes
Authentication support Yes LDAP
SSL
RADIUS
PAM
Kerberos
GSSAPI
SSPI
Trust
Password
Ident
LDAP
SSL
RADIUS
PAM
Kerberos
GSSAPI
SSPI
Trust
Password
Ident
DB Connection Encryption Yes SSL SSL
DB Connection White Lists Yes Yes Yes
DB Connection Black Lists Yes Yes Yes

 

Function Package Descriptions for EDB Postgres Advanced Server

Return to Feature Differences - Packages

 
Package Name
 
Package Description
DBMS_ALERT Functions that allow asynchronous notification of database events via an Alert. Using this package and triggers, an application can notify itself whenever values of interest in the database are changed.
DBMS_AQ Database integrated Message Queuing functions allowing applications to communicate with each another via asynchronous messages to the database.
DBMS_CRYPTO Yes Provides functions to encrypt and decrypt stored data.
DBMS_JOB Has been replaced by DBMS_SCHEDULER but included for compatibility with older Oracle applications.
DBMS_LOB Functions that allow access to and manipulation of Large OBject values.
DBMS_LOCK Provides a function interface to Lock Management services.
DBMS_OUTPUT Allows the sending of messages from stored procedures, packages, and triggers for application or debugging use.
DBMS_PIPE Functions that allow two or more sessions in the same database instance to communicate with one another.
DBMS_PROFILER Provides functions to profile stored procedure workloads and identify performance bottlenecks.
DBMS_SCHEDULER Job scheduler functions for creating and executing unattended repetitive tasks inside the database.
DBMS_SQL Permits the use of dynamic SQL in procedures to allow applications to run SQL statements with unknown parameters (such as table name) until runtime.
DBMS_RANDOM Useful functions to generate random text, numeric and date values.
DBMS_RLS Yes Implements row level security functions in the database blocking users from seeing each other's data in the same application.
DBMS_SESSION Yes Functions with the ability to enable and disable roles.
DBMS_UTLTITY A collection of functions for getting information about various runtime operations and meta data from the database.
UTL_ENCODE Functions to perform Base64 encoding and decoding of data intended for transport between hosts.
UTL_FILE Allows database procedures to read and write operating system text files in an I/O stream fashion.
UTL_HTTP Functions that provide the ability to make HTTP calls to access information on web servers.
UTL_MAIL Provides functions to create,manage, and send email from the database including attachments, CC, and BCC.
UTL_RAW Functions supporting the manipulation of raw data types.
UTL_SMTP Provides functions for sending mail via SMTP according to the RFC821 specification.
UTL_URL Functions for escaping and un-escaping URL strings.
For complete specifications for each supported Function Package see the Database Compatibility for Oracle® Developer's Guide in the Documentation section.

 

Back to top