10

I try to use Spring Data R2DBC with postgres.

I know some configuration for url, username, password.

spring.r2dbc.url
spring.r2dbc.username
spring.r2dbc.password

Is there something for the schema? Any list of setting available?

mp911de
  • 17,546
  • 2
  • 55
  • 95
robert trudel
  • 5,283
  • 17
  • 72
  • 124

2 Answers2

11

Schema is Postgres-specific and can be configured through the R2DBC Connection URL:

r2dbc:postgresql://<server>:<port>/<database>?schema=<yourSchema>

See also:

mp911de
  • 17,546
  • 2
  • 55
  • 95
10

More pretty way to pass schema in properties: in yaml format:

spring:
  r2dbc:
    properties:
      schema: <yourSchema>

or properties format:

spring.r2dbc.properties.schema: <yourSchema>
antoniOS
  • 370
  • 2
  • 9