PostgreSQL Data Access Components (PgDAC)PostgreSQL Data Access Components (PgDAC)

DevartData Access ToolsVCL Component
Version 10.0.1 (Jun 15, 2026)

Native PostgreSQL connectivity components for Delphi, C++Builder, and Lazarus.

  • Connect directly to PostgreSQL servers without requiring client libraries.
  • Execute queries, scripts, and stored procedures from Delphi, C++Builder, and Lazarus applications.
  • Access PostgreSQL features with optimized dataset and data access components.
Devart logo

Prices from:

Loading...
Available individuallyOur Price
PostgreSQL Data Access Components (PgDAC)Loading
Data access components for PostgreSQL.
PostgreSQL Data Access Components (PgDAC) is a library of components designed for fast and reliable interaction with PostgreSQL databases. It enables applications to connect directly to PostgreSQL servers, execute SQL queries, manage transactions, and work with PostgreSQL specific database features through native components integrated into Delphi, C++Builder, and Lazarus environments.

Direct PostgreSQL Connectivity

Allows applications to connect directly to PostgreSQL servers through the native protocol without requiring the PostgreSQL client library, simplifying deployment and configuration.

PostgreSQL Feature Support

Provides support for PostgreSQL capabilities such as sequences, large objects, domain and composite types, and asynchronous notifications.

High-Performance Data Access

Implements optimized data access algorithms and connection management features to support efficient interaction with PostgreSQL databases.

Advanced Dataset Management

Includes components for querying data, executing SQL scripts, and working with datasets that support sorting, filtering, and master-detail relationships.

Stored Procedure and Function Execution

PgDAC provides components for executing PostgreSQL stored procedures and functions directly from applications. It supports input and output parameters as well as returning result sets, allowing developers to integrate database side logic and procedural operations within application workflows.

PostgreSQL Data Type and Large Object Support

PgDAC supports a wide range of PostgreSQL data types including arrays, composite types, domains, and large objects. This enables applications to work with complex PostgreSQL structures and large data values while maintaining compatibility with Delphi dataset components.

Script Execution and Batch Processing

PgDAC includes components for executing SQL scripts and batches of statements directly from applications or script files. This functionality helps developers automate database setup, maintenance tasks, and bulk data operations within PostgreSQL environments.

Connection Pooling

PgDAC supports connection pooling to reuse established PostgreSQL connections across multiple database operations. By maintaining a pool of active connections, applications can reduce the overhead associated with repeatedly opening and closing sessions, improving performance and scalability in environments with frequent database access.

Asynchronous Notification Support

PgDAC supports PostgreSQL asynchronous notifications using the LISTEN and NOTIFY mechanism. Applications can subscribe to database events and receive notifications when specific actions occur, enabling event driven communication between PostgreSQL and client applications.

Comprehensive Component Library

Includes components such as TPgQuery, TPgTable, TPgStoredProc, and TPgScript that enable developers to execute queries, manage database objects, and automate database tasks.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • VCL Component

IDE Support

  • C++Builder
  • Delphi
  • RAD Studio