PgDAC

TPgConnection Members

TPgConnection class overview.

Properties

Name Description

ConnectDialog (inherited from TCustomDAConnection)

Allows to link a TCustomConnectDialog component.

ConnectionTimeout

Used to set the time to wait while trying to establish a connection before terminating the attempt and generating an error.

ConnectString (inherited from TCustomDAConnection)

Used to specify the connection information, such as: UserName, Password, Server, etc.

ConvertEOL (inherited from TCustomDAConnection)

Allows customizing line breaks in string fields and parameters.

Database

Used to specify the name of the database to be used once a connection is open.

InTransaction (inherited from TCustomDAConnection)

Indicates whether the transaction is active.

LoginPrompt (inherited from TCustomDAConnection)

Specifies whether a login dialog appears immediately before opening a new connection.

Options

Specifies the behaviour of the TPgConnectionOptions object.

Password

Used to specify a password for a connection.

Pooling (inherited from TCustomDAConnection)

Enables or disables using connection pool.

PoolingOptions (inherited from TCustomDAConnection)

Specifies the behaviour of connection pool.

Port

Used to specify the port for connection.

ProcessID

Returns the process ID (PID) of the backend server process handling this connection.

ProtocolVersion

Used to set the version of protocol for communication with PostgreSQL server.

Schema

Used to change the search path of the connection to the specified schema, or get the first value from the search path.

Server

Contains the server name.

ServerVersion

Holds the PostgreSQL server version number.

ServerVersionFull

Holds full PostgreSQL server version including version number and some additional information.

SSLOptions

Used to set the properties required for protected SSL connection with the server.

Username

Contains username.

Methods

Name Description

ApplyUpdates (inherited from TCustomDAConnection)

Overloaded. Applies changes in datasets.

BreakExec

Used to cancel a query that is currently being executed on the connection.

Commit (inherited from TCustomDAConnection)

Commits current transaction.

Connect (inherited from TCustomDAConnection)

Establishes a connection to the server.

CreateDataSet

Returns a new instance of TPgQuery class and associates it with the connection object.

CreateMetaData

Returns a new instance of the TPgMetaData class.

CreateSQL

Returns a new instance of TPgSQL class and associates it with the connection object.

CreateTransaction

Returns a new instance of the TPgTransaction class.

Disconnect (inherited from TCustomDAConnection)

Performs disconnect.

ExecProc (inherited from TCustomDAConnection)

Allows to execute stored procedure or function providing its name and parameters.

ExecProcEx (inherited from TCustomDAConnection)

Allows to execute a stored procedure or function.

ExecSQL (inherited from TCustomDAConnection)

Executes a SQL statement with parameters.

ExecSQLEx (inherited from TCustomDAConnection)

Executes any SQL statement outside the TQuery or TSQL components.

GetDatabaseNames (inherited from TCustomDAConnection)

Returns a database list from the server.

GetKeyFieldNames (inherited from TCustomDAConnection)

Provides a list of available key field names.

GetRowType

Overloaded. Used to get a TPgRowType object for composite type.

GetStoredProcNames (inherited from TCustomDAConnection)

Returns a list of stored procedures from the server.

GetTableNames (inherited from TCustomDAConnection)

Provides a list of available tables names.

MonitorMessage (inherited from TCustomDAConnection)

Sends a specified message through the TCustomDASQLMonitor component.

Ping (inherited from TCustomDAConnection)

Used to check state of connection to the server.

ReleaseSavepoint

Releases the specified savepoint without affecting any work that has been performed after its creation.

RemoveFromPool (inherited from TCustomDAConnection)

Marks the connection that should not be returned to the pool after disconnect.

Rollback (inherited from TCustomDAConnection)

Discards all current data changes and ends transaction.

RollbackToSavepoint

Cancels all updates for the current transaction.

Savepoint

Defines a point in the transaction to which you can roll back later.

StartTransaction

Overloaded. Starts a new user transaction against the database server.

Events

Name Description

OnConnectionLost (inherited from TCustomDAConnection)

This event occurs when connection was lost.

OnError (inherited from TCustomDAConnection)

This event occurs when an error has arisen in the connection.

OnNotice

Occurs when a message or notice is received from PostgreSQL server.

OnNotification

Occurs when an asynchronous notification is received from PostgreSQL server.
© 1997-2020 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback