PostgresDAC

TPSQLDatabase.Properties.DatabaseID

Previous Next

Specifies the ID (oid) of the database associated with this database component.

Syntax:

property DatabaseID: cardinal;

Description:

Use read-only DatabaseID property to get unique integer value which identifies database within cluster.

You can use DatabaseID property for low level calls to server.

Example:

This example shows SQL statement that returns last system inserted OID in the database

PSQLQuery1.SQL.Text := Format('SELECT datlastsysoid FROM pg_database ' + 
	'WHERE oid = ''%u''',
	[PSQLQuery1.Database.DatabaseID]);
Since OID type is unsigned integer be carefull when mixing integer types in your application!