Postgre Database connection

Ignition
1

Hi, I trying to connect to a postgre database, the connection string is this

jdbc:postgresql://localhost:5432/postgredb

By default the data is stored in the public squema, but I want to store the data in a different esquema, how can I do this?

2

A Google search suggests that jdbc:postgresql://localhost:5432/postgredb?searchpath=myschema might work. Can you try it and let me know?

3

still does not work, the data is stored in the public schema, thanks anyway.

4

Hi ,

Ignition database connection for postgresql can connect to database but how to point the DB connection to particular schema in that database. I have tried by changing the connection URL to jdbc:postgresql://localhost:5432/postgredb?searchpath=myschema It didn’t worked for me.
I wanted to configure auditing profile for gateway and the auditing profile pointing to Ignition database connection so the AUDIT_EVENT table will be automatically created in the schema as per my requirement.

Thanks
Hari Gb

5

Maybe this: postgresql schema …?

1 Like
6

According to the documentation, it should be currentSchema

jdbc:postgresql://localhost:5432/postgredb?currentSchema=myschema

2 Likes