4 replies

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

attrs

still be

Record<string, JSONValue> | null

Record<string, JSONValue> | null

. How to get rid of the

null

null

Solution

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

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

4 replies

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

attrs

still be

Record<string, JSONValue> | null

Record<string, JSONValue> | null

. How to get rid of the

null

null

Solution

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

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