PgDAC

Component List

This topic presents a brief description of the components included in the PostgreSQL Data Access Components library. Click on the name of each component for more information. These components are added to the PgDAC page of the Component palette except for TCRBatchMove and TVirtualTable components. TCRBatchMove and TVirtualTable components are added to the Data Access page of the Component palette. Basic PgDAC components are included in all PgDAC editions. PgDAC Professional Edition components are not included in PgDAC Standard 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.
VirtualDataSet TVirtualDataSet Dataset that processes arbitrary non-tabular data.

PgDAC Professional Edition components

PgEncryptor TPgEncryptor Represents data encryption and decryption in client application.
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 specified SQL object.
CRBatchMove TCRBatchMove Retrieves metadata on database objects from the server.

See Also

© 1997-2020 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback