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.