1
How to Store multiple values in a column?
Source: supabase/supabase#1878 · opened by @maheshj01
I would like to add a column to my table that takes in a set of values like an array. But in the available set of types, I don't see any type that allows adding multiple values in a row.
Available types that I See.
E.g I have a table which has columns words,meanings, synonyms
The column synonym can have multiple values
Heres what I am expecting
|Words | Meanings |Synonyms | something |something |
|---|---|---|---|---|
|word1 | Meaning1 | [synonym1,synonym2] | | |
|word2 | Meaning2 |[synonym1] | | |
|word3 | Meaning3 | [synonym1,synonym2,Synonym3] | | |
I do understand there are hackable ways like storing comma-separated-values, But I am curious if multiple values are allowed if not if there are any plans to add them in the future? or is there any limitation with the database. Sorry if my question is irrelevant I really don't have much idea about the databases.
Available types that I See.
E.g I have a table which has columns words,meanings, synonyms
The column synonym can have multiple values
Heres what I am expecting
|Words | Meanings |Synonyms | something |something |
|---|---|---|---|---|
|word1 | Meaning1 | [synonym1,synonym2] | | |
|word2 | Meaning2 |[synonym1] | | |
|word3 | Meaning3 | [synonym1,synonym2,Synonym3] | | |
I do understand there are hackable ways like storing comma-separated-values, But I am curious if multiple values are allowed if not if there are any plans to add them in the future? or is there any limitation with the database. Sorry if my question is irrelevant I really don't have much idea about the databases.
No pledges yet. Be the first to back this.
Comments
Similar requests
Improve Column Name Copying and Visibility in Tables
1 vote · 0 comments
[Supabase-js] Support ordering numeric column ascending but push zeros and/or negatives to the end
1 vote · 0 comments
Add a "Duplicate row" action to the Table Editor
1 vote · 0 comments
Add the ability to change the position of table columns
5 votes · 0 comments
Suggestion: Renaming some filters
1 vote · 0 comments
No comments yet.