define a jsonb column with `{}` as default value does not work

I'm trying to define a jsonb column with default value like this:

  attrs: pg
    .jsonb('attrs')
    .$type<Record<string, JSONValue>>()
    .default(sql`'{}'::jsonb`),

  attrs: pg
    .jsonb('attrs')
    .$type<Record<string, JSONValue>>()
    .default(sql`'{}'::jsonb`),

however, the inferred type definition of attrs still be Record<string, JSONValue> | null. How to get rid of the null?

Solution:

``ts
attrs: pg
    .jsonb('attrs')
    .$type<Record<string, JSONValue>>()
    .default(sql

'{}'::jsonb`).notNull(),...

3 Replies

Angelelz•13mo ago

What if you add .notNull()?

Solution

Angelelz•13mo ago

attrs: pg
    .jsonb('attrs')
    .$type<Record<string, JSONValue>>()
    .default(sql`'{}'::jsonb`).notNull(),

attrs: pg
    .jsonb('attrs')
    .$type<Record<string, JSONValue>>()
    .default(sql`'{}'::jsonb`).notNull(),

nightireOP•13mo ago

@Angelelz Thank you, it works, I don't expect that easy.