PostgresDAC

TPSQLTable.Properties.Tablespace

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 nescessary.

Example:

This example show 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''',
	[PSQLTable1.Tablespace]);