SET_PGSQL_TOOLS_SCHEMA

Applies to: PGFlex

The driver needs access to some stored functions to properly support all the features of Dataflex in PostgreSQL. These functions are by default stored in the public schema. This command allows those functions to be stored in some other schema. To use this feature, you must call this command passing it the schema in which the functions are stored BEFORE logging into the server. If the schema doesn’t have the needed functions this command will also try to add them to that specified schema for you.

Syntax

SET_PGSQL_TOOLS_SCHEMA {schema}

Parameter

Description

schema

The name of the schema to use for driver tools/functions.

Example

SET_PGSQL_TOOLS_SCHEMA "MertechTools"