TPgConnection.Schema Property

Used to change the search path of the connection to the specified schema, or get the first value from the search path.

Class

TPgConnection

Syntax

property Schema: string stored IsSchemaStored;

Remarks

Use the Schema property to change the search path of the connection to the specified schema, or get the first value from the search path.

Set the Schema property to change the search path of the connection to the specified schema. When connection is open, read the value of the property to get the name of the current schema (the first value from the current search path).

The TPgQuery, TPgStoredProc and other PgDAC components can implicitly use this property. Therefore you may have problems in case your search path contains several schemas and you use objects not from the current one.