Invalid schema name processing

If you specify a schema that does not match the database owner name, the schema is invalid.

The enable_schema_dbo_check variable specifies the actions that the system takes when processing a query with an invalid schema. The possible actions are as follows:

0

Causes the system to ignore the user-specified schema and use the default schema. This is the default.

1

Causes the system to ignore the user-specified schema and use the default; the system displays the warning Schema 'schema_name' does not exist.

2

Causes the system to fail the query with the error Schema 'schema_name' does not exist.

• You can set the enable_schema_dbo_check variable in the postgresql.conf file, or you can change the behavior on a session level using the SET enable_schema_dbo_check=value SQL command.