CODEWITHSUNDEEP
postgresqlspring-boot
Tisha
Tisha

Reputation: 857

How can I set a database schema in a springboot project?

I am developing a flyway project.

I tried setting schema using the property 

spring.datasource.schema=myschema

However, this didn't help.

The project just consist of versions sql files that need to be executed to build the database schema.

How can I specify the database schema?

I do not want to alter the search_path and set it to myschema as the database is being used by other applications and they need to connect to the mainschema.

Upvotes: 0

Views: 79

Answers (1)

user330315
user330315

Reputation:

As documented in the manual you can append the current schema to the JDBC URL:

jdbc:postgresql://localhost/database_name?currentSchema=myschema

Upvotes: 1

Related Questions