Hey folks trying to insert value of a string array...
# help
j
Hey folks trying to insert value of a string array in the table editor and I'm gettting "invalid array" I've tried the following values: -
{'admin'}
-
'{"admin"}'
-
['admin']
Can't really get it to work?
n
Hello @jaitaiwan! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
🆕 Inserting text[] in table editor
t
I don't find it intutive though you need the
ARRAY
keyword
Copy code
ARRAY['user'::text, 'admin'::text]
n
Inserting text[] in table editor
j
Thanks heaps @tourdownunder
I was able to use
"{admin}"
to get it to work. A trigger function was breaking and being the actual cause but the message was hidden in the ui because I had shrunk the viewport
n
Thread was archived by @jaitaiwan. Anyone can send a message to unarchive it.