Postgres database "information_schema" in JPA

Question

I've created project using Postgres database. Tables are created in information_schema, that's why I need to add schema argument @Table or @JoinTable, like this:

@Entity
@Table(name = "book",  schema = "information_schema")
public class Book { ...

@ManyToMany
@JoinTable(
    name = "book_genre",
    schema = "information_schema",
    joinColumns = @JoinColumn(name = "book_id"),
    inverseJoinColumns = @JoinColumn(name = "genre_id"))
private List<Genre> genres = new ArrayList<>();

What setting should I change to avoid this? Maybe I should set it in settings of my application?
application.yml looks like this:

spring:
  datasource:
    url: "jdbc:postgresql://localhost:5432/postgres"
    username: ...
    password: ...

@ScaryWombat It is not the schema, it is the database (a.k.a. catalog in JDBC terminology) — Mark Rotteveel
– Mark Rotteveel, Commented Dec 23, 2022 at 12:11

Shakirov Ramil · Accepted Answer · 2022-12-23 06:42:13Z

1

spring:
  datasource:
    hikari:
      schema: ${database.schema}
  liquibase:
    default-schema: ${database.schema}
  jpa:
    properties:
      hibernate:
        default_schema: ${database.schema}

answered Dec 23, 2022 at 6:42

Shakirov Ramil

1,5741 gold badge12 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Postgres database "information_schema" in JPA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related