Spring Boot - How to set the default schema for PostgreSQL?

Question

What I am currently doing in my application.properties file is:

spring.datasource.url=jdbc:postgresql://localhost:5432/myDB?currentSchema=mySchema

Isn't there another property for this? Since it looks hacky and according to a post (still finding the link sorry, will update later), it is only applicable to PostgreSQL 9.4.

Steffen · Accepted Answer · 2019-02-12 13:29:40Z

15

Since this is quite old and has no proper answer yet, the right property to set is the following:

spring.jpa.properties.hibernate.default_schema=yourschema

answered Feb 12, 2019 at 13:29

Steffen

4,3091 gold badge27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RomanMitasov Over a year ago

And what about JDBC configuration, not JPA?

Pearl Over a year ago

Setting currentSchema=mySchema for JDBCTemplate is not working. I'm using postgres 12.

Juan · Accepted Answer · 2021-12-16 15:51:09Z

6

With SpringBoot 2.5.5 the only thing that work for me:

aplication.properties

spring.datasource.hikari.schema=my_schema

aplication.yml version:

spring:
  datasource:
    hikari:
      schema: my_schema

answered Dec 16, 2021 at 15:51

Juan

5749 silver badges23 bronze badges

Comments

Ahmed Ashour · Accepted Answer · 2023-03-15 06:42:02Z

5

You can try setting the default schema for the jdbc user.

ALTER USER user_name SET search_path to 'schema'
Did you try this property?

spring.datasource.schema

http://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html

edited Mar 15, 2023 at 6:42

Ahmed Ashour

5,66310 gold badges41 silver badges63 bronze badges

answered Jun 15, 2015 at 15:25

jcalloway

1,1551 gold badge15 silver badges24 bronze badges

1 Comment

Rey Libutan Over a year ago

Thanks for this! I tried this and this works but as much as I possible, I want to set it somewhere in my application (I also don't want to execute sql files for this somewhere).

Collectives™ on Stack Overflow

Spring Boot - How to set the default schema for PostgreSQL?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related