Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

AdvancedAdvanced PostgreSQL

Spring Data JPA & PG: JSONB mapping (Part 12)

The query

SQL
-- Q: How does Hibernate interact with PostgreSQL regarding JSONB mapping?
@Entity
public class PracticeEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    private Long id;
}
Tested against PostgreSQL 16

Note

“Using GenerationType.SEQUENCE is vastly superior to IDENTITY in PostgreSQL for bulk inserts.