PgDAC Component List

Basic PgDAC components are included in all PgDAC editions. There are additional components in PgDAC Professional and Developer Edition. The Editions page gives full description of features and included components of each edition.

Basic PgDAC components

PgConnection

TPgConnection
Represents an open connection to a PostgreSQL database.

PgQuery

TPgQuery
Executes queries and Operates record sets. It also provides flexible way to update data.

PgSQL

TPgSQL
Executes SQL statements and stored procedures, which do not return rowsets.

PgTable

TPgTable
Lets you retrieve and update data in a single table without writing SQL statements.

PgStoredProc

TPgStoredProc
Has access to and executes stored procedures and functions.

PgUpdateSQL

TPgUpdateSQL
Lets you tune update operations for the DataSet component.

PgDataSource

TPgDataSource
Provides an interface between PgDAC dataset components and data-aware controls on a form.

PgScript

TPgScript
Executes sequences of SQL statements.

PgSQLMonitor

TPgSQLMonitor
Interface for monitoring dynamic SQL execution in PgDAC-based applications.

PgConnectDialog

TPgConnectDialog
Used to build custom prompts for username, password and server name.

VirtualTable

TVirtualTable
Dataset that stores data in memory. This component is placed on the Data Access page of the Component palette, not on the PostgreSQL Access page.

PgDAC Professional Edition components

PgAlerter

TPgAlerter
Registers interest in and asynchronously handles event notifications posted by PostgreSQL server.

PgLoader

TPgLoader
Provides quick loading of external data into the server database.

PgDump

TPgDump
Serves to store a database or its parts as a script and also to restore database from received script.

PgMetaData

TPgMetaData
Retrieves metadata on database objects from the server.

PgEncryptor

TPgEncryptor
Represents data encryption and decryption in client application.

CRBatchMove

TCRBatchMove
Transfers data between all types of TDataSets descendants. This component is placed on the Data Access page of the Component palette, not on the PostgreSQL Access page.