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

Get PricingLearn More

 

 

Feature by Feature Comparison

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

 

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

 

 

Get Pricing

  

 

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 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