Dump the contents of specified schemas only.
Syntax:
property SchemaNames: TStrings;
Description:
If this property is empty, all non-system schemas in the target database will be dumped. If not then the contents of specified schemas dumped only. POSIX regular expressions are handled also.
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');
In this mode, TPSQLDump makes no attempt to dump any other database objects that objects in the selected schema may depend upon. Therefore, there is no guarantee that the results of a single-schema dump can be successfully restored by themselves into a clean database.
See also: ExcludeSchemas, TableNames