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

	TPgConnection	Represents an open connection to a PostgreSQL database.
	TPgQuery	Executes queries and Operates record sets. It also provides flexible way to update data.
	TPgSQL	Executes SQL statements and stored procedures, which do not return rowsets.
	TPgTable	Lets you retrieve and update data in a single table without writing SQL statements.
	TPgStoredProc	Has access to and executes stored procedures and functions.
	TPgUpdateSQL	Lets you tune update operations for the DataSet component.
	TPgDataSource	Provides an interface between PgDAC dataset components and data-aware controls on a form.
	TPgScript	Executes sequences of SQL statements.
	TPgSQLMonitor	Interface for monitoring dynamic SQL execution in PgDAC-based applications.
	TPgConnectDialog	Used to build custom prompts for username, password and server name.
	TVirtualTable	Dataset that stores data in memory. This component is placed on the Data Access page of the Component palette.
	TVirtualDataSet	Dataset that processes arbitrary non-tabular data.

PgDAC Professional Edition components

	TPgEncryptor	Represents data encryption and decryption in client application.
	TPgLoader	Provides quick loading of external data into the server database.
	TPgDump	Serves to store a database or its parts as a script and also to restore database from received script.
	TPgMetaData	Retrieves metadata on specified SQL object.
	TCRBatchMove	Retrieves metadata on database objects from the server.

See Also

• Hierarchy chart