Prevent Postgres column to be EMPTY using supabase & prisma

Question

I've started a new project using Prisma & Supabase but I'm facing an issue.

I have some required String columns. Is there a way to prevent those columns to accept empty string value ('').

Do you know if this can be done at the prisma schema level (this would be the best option I guess)? Or using subapase RLS policies?

`alter table test add constraint disallow_empty_that_column check(that_column<>'');` — Zegarek, Dec 30 '22 at 14:34
Is it okay to accept `NULL`, @BghinC? Just empty strings is the problem? — Mansueli, Dec 30 '22 at 14:46

score 1 · Answer 1 · answered Dec 30 '22 at 14:46

You can achieve that with a check constraint:

alter table my_table 
add constraint disallow_empty_in_that_column check(that_column<>'');

You can do the same with RLS:

create table test2(a text);
alter table test2 enable row level security;
alter table test2 force row level security;--applies this to table owner as well
create policy disallow_empty_in_that_column on test2 using ( a<>'' );

Online demo

Prevent Postgres column to be EMPTY using supabase & prisma

1 Answers1