This article provides you with the frequently asked questions related to ContentConnector PostgreSQL. Please see the links below and post any questions in the comments area. If you cannot find what you are looking for, please Ask a Question HERE for DataSource.
Can I run ContentConnector on a schema other than the default public schema?
-
Yes — starting with ContentConnector version 2.2.31, ContentConnector PostgreSQL can be configured to run on any schema other than the default public schema.
-
By default, the connector uses the public schema. To explicitly specify a different schema, first create the schema in PostgreSQL and then use the currentSchema parameter in the PostgreSQL connection URL. For example:
<ServerURL>jdbc:postgresql://SERVER:5432/DATABASE?currentSchema=SchemaName</ServerURL>