PostgresDAC

TPSQLDump.Properties.ExcludeSchemas

Previous Next

Exclude contents of specified schemas from the dump process.

Syntax:

property ExcludeSchemas: TStrings;

Description:

Do not dump any schemas matching the schema pattern. The pattern is interpreted according to the same rules as for SchemaNames property.

When both SchemaNames and ExcludeSchemas are given, the behavior is to dump just the schemas that match at least one SchemaNames switch but no ExcludeSchemas switches. If ExcludeSchemas appears without SchemaNames, then schemas matching ExcludeSchemas are excluded from what is otherwise a normal dump.

Example:

This example shows how to dump all schemas starting with east or west and ending in gsm, but not schemas that contain the letters test, except for one named east_alpha_test_five

PSQLDump.SchemaNames.Clear; 
PSQLDump.SchemaNames.Append('"^(east|west).*gsm$"');
PSQLDump.SchemaNames.Append('east_alpha_test_five');
PSQLDump.ExcludeSchemas.Clear;
PSQLDump.ExcludeSchemas.Append('test');
See also:SchemaNames, TableNames