Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

Postgres DB Configuration: Accessing a postgre schema


Level 1
I am looking for a way to set up a connection to a postgre non-public schema in AC Classic. Normally the connection to the postgre database uses the public schema. So in the instance configuration file you can set the user, password, and connection and server.  However, in case I want to group several schemas inside one postgre database, I would need to specify the schema to connect. For example, the idea is to have a schema for app, another for frontal, and another for message center. All of the schemas would be under one pg database.

The normal database configuration looks as follows
<dataSource name="default">

                <dbcnx encrypted="1" login="username:database" password="xxx" provider="postgres" server="localhost:5432" />

is there a way to specify in the datasource to connect to a specific postgres schema?
0 Replies