PostgresDAC

TPSQLDatabase.Properties.Tablespace

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]);