Compare Postgres Databases

EDB Postgres™ Advanced Server vs PostgreSQL

The Features You Need to Operate at Scale

PostgreSQL requires additional tools and capabilities to operate at scale. EDB Postgres Platform offers:

  •  

    Enterprise-ready tools for high availability, monitoring, disaster recovery and manageability

  •  

    Increased security and other enterprise features

  •  

    Oracle compatibility

  •  

    More deployment options

  •  

    Enhanced integration

  •  

    Enhanced DBA and developer productivity

  •  

    24x7 “Follow-the-Sun” support

Feature by Feature Comparison

Learn which Postgres database will provide the tools and functionality you're looking for.

 
  •  

    Denotes Oracle® database compatibility

 

Enterprise Security Features

Feature PostgreSQL EDB Postgres Advanced Server
Data Redaction
 
 
Password Profiles
 
 
EDB SQL/Protect
 
 
Enhanced Audit Logging
 
 
Server Procedural Language Protection (EDB*Wrap)
 
 

Enterprise Performance Features

Feature PostgreSQL EDB Postgres Advanced Server
Query Optimizer Hints
 
 
SQL Session/System Wait Diagnostics
 
 
Advanced Performance Analytics
 
 

Enterprise Developer Features

Feature PostgreSQL EDB Postgres Advanced Server
Autonomous Transactions
 
 
Hierarchical Queries
 
 
22 Pre-defined, Re-usable Function Packages
 
 
Synonyms (Public and Private)
 
 
Extended Functions and Operators
 
 
Bulk Collect and Binds
 
 
User Defined Object Types
 
 
Nested Tables
 
 
User Defined Exceptions
 
 
User Defined Packages and Functions
 
 
Associative Arrays
 
 
VARRAYs
 
 
edb_stmt_level_txn
 
 
EDB*Plus
 
 
ECPGPlus
 
 

Enterprise DBA Features

Feature PostgreSQL EDB Postgres Advanced Server
Resource Management
 
 
EDB*Loader
 
 
Extended Catalog Views
 
 

Database Compatibility for Oracle

Feature PostgreSQL EDB Postgres Advanced Server
Free Migration Assessment Portal in the Cloud
 
 
Data Type Compatibility
 
 
Automated Migration of Schema, Data, and Objects
 
 
PL/SQL Support in Stored Procedures and Triggers
 
 
PL/SQL Debugger
 
 
EDB*OCI
 
 
Pro*C Support
 
 
Bulk Data Loader
 
 
Interactive and Batch Command-Line Processor
 
 
Replication with Oracle (*uses EDB Postgres Replication Server)
 
 

Function Package Descriptions for EDB Postgres Advanced Server

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 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_REDACT Generic and scalable policy mechanism functions to assign different types of redaction based on column data type protecting sensitive information like Social Security or Credit Card numbers in support of security initiatives like GDPR, HIPPA and PCI-DSS.
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 Implements row level security functions in the database blocking users from seeing each other's data in the same application.
DBMS_SESSION 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.