EPUB | CHM | PDF

TPSQLDatabase.Properties.Tablespace

Top Previous Next

Specifies the database tablespace name within the cluster.

Syntax:

property Tablespace: string;

Description:

Use read-only Tablespace property to get name of tablespace within this database is stored on server side platform.

You can use Tablespace property for low-level calls to server.

Example:

This example shows SQL statement that returns directory on server paltform wich stores objects of some tablespace:

PSQLQuery1.SQL.Text := Format('SELECT spclocation FROM pg_tablespace ' +
 'WHERE spcname = ''%s''',
 [PSQLQuery1.Database.Tablespace]);