Please see TPSQLDatabase methods short descriptions below:
Closes the connection.
Closes all datasets associated with the database component without disconnecting from the database server.
Permanently stores updates, insertions, and deletions of data associated with the current transaction, and ends the current transactions.
Creates an instance of a TPSQLDatabase component.
Destroys the instance of a database component.
Executes an SQL statement.
Populates a stringlist with the names of persistent PostgreSQL databases.
Returns the process ID of the backend server handling this connection.
Returns list of charsets available for client encoding.
Returns list of stored procedures available at the moment.
Populates a string list with the names of schemas associated with a specified database component.
Populates a string list with the names of users associated with a specified database component.
Opens the connection.
Destroy a previously defined savepoint.
Resets the communication channel to the server.
Cancels all updates, insertions, and deletions for the current transaction and ends the transaction.
Roll back to a savepoint.
Establishes a new savepoint within the current transaction.
Methods of this group execute SQL Query and return result as single value casted to the string type.
Executes SQL Query and return result into TStrings object passed as parameter.
Begins a new transaction against the database server.