Menu
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?
370
PostgreSQL has a CREATE SCHEMA statement that is used to create a new schema in a database. Syntax: CREATE SCHEMA [IF NOT EXISTS] schema_name; Let's analyze the above syntax: First, specify the name of the schema after the CREATE SCHEMA keywords.
The output will be, After creating a new schema, you can make it a default schema instead of a public schema. To make a schema default, the search_path variable is used. Search_path variable defines the schema order in which they are searched when an object is referenced without any schema name.
Schema is Postgres-specific and can be configured through the R2DBC Connection URL:
r2dbc:postgresql://<server>:<port>/<database>?schema=<yourSchema>
See also:
137
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
