Compare PostgreSQL databases

* Denotes Oracle database compatibility


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


PostgreSQLEDB Postgres Advanced Server
Query Optimizer Hints *
SQL Session/System Wait Diagnostics *
Advanced Performance Analytics


PostgreSQLEDB Postgres Advanced Server
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 *
edb_stmt_level_txn *
EDB*Plus *


PostgreSQLEDB Postgres Advanced Server
Resource Management
EDB*Loader *
Extended Catalog Views *

Oracle Compatibility

PostgreSQLEDB 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 *
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 NamePackage Description
DBMS_ALERTFunctions 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_AQDatabase integrated Message Queuing functions allowing applications to communicate with each another via asynchronous messages to the database.
DBMS_CRYPTOProvides functions to encrypt and decrypt stored data.
DBMS_JOBHas been replaced by DBMS_SCHEDULER but included for compatibility with older Oracle applications.
DBMS_LOBFunctions that allow access to and manipulation of Large OBject values.
DBMS_LOCKProvides a function interface to Lock Management services.
DBMS_OUTPUTAllows the sending of messages from stored procedures, packages, and triggers for application or debugging use.
DBMS_PIPEFunctions that allow two or more sessions in the same database instance to communicate with one another.
DBMS_PROFILERProvides functions to profile stored procedure workloads and identify performance bottlenecks.
DBMS_REDACTGeneric 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_SCHEDULERJob scheduler functions for creating and executing unattended repetitive tasks inside the database.
DBMS_SQLPermits the use of dynamic SQL in procedures to allow applications to run SQL statements with unknown parameters (such as table name) until runtime.
DBMS_RANDOMUseful functions to generate random text, numeric and date values.
DBMS_RLSImplements row level security functions in the database blocking users from seeing each other's data in the same application.
DBMS_SESSIONFunctions with the ability to enable and disable roles.
DBMS_UTLTITYA collection of functions for getting information about various runtime operations and meta data from the database.
UTL_ENCODEFunctions to perform Base64 encoding and decoding of data intended for transport between hosts.
UTL_FILEAllows database procedures to read and write operating system text files in an I/O stream fashion.
UTL_HTTPFunctions that provide the ability to make HTTP calls to access information on web servers.
UTL_MAILProvides functions to create,manage, and send email from the database including attachments, CC, and BCC.
UTL_RAWFunctions supporting the manipulation of raw data types.
UTL_SMTPProvides functions for sending mail via SMTP according to the RFC821 specification.
UTL_URLFunctions for escaping and un-escaping URL strings.

For complete specifications for each supported function package see the docs for EDB Postgres Advanced Server.