How can i create a schema to the database?

Hi, how can i create a column which is an array of objects like

 id: string;
  name: string;
  artist: string[];
  cover: string;

 id: string;
  name: string;
  artist: string[];
  cover: string;

Thanks

10 Replies

garyaustin•3y ago

In the dashboard table UI you just select text type and check array. In SQL you just use text [] when creating the table or ALTER TABLE candidate ADD COLUMN my_array_col text[]

TalajaxOP•3y ago

So i can create it as text[] and i won't have any problems?

garyaustin•3y ago

Maybe I'm missing what you want to do. Are you wanting an array of the whole thing you showed, or is that your table you are looking for? If the whole thing you showed is an object and you want an array of those, then you would be looking at json or jsonb array column

TalajaxOP•3y ago

Yes, what i want is an array of that whole object

TalajaxOP•3y ago

So this should do the work?