EPUB | CHM | PDF

TPSQLTable.Properties.Tablespace

Top Previous Next

Specifies the table tablespace name within the cluster.

Syntax:

property Tablespace: string;

Description:

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

You can use Tablespace property for low level calls to server. Usually, tables are stored within their database tablespace, but it is not necessary.

Example:

This example show SQL statement that returns directory on server platform which stores objects of some tablespace:

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