PostgreSQL array column creation from web ui?

[cyan holly]

Hey all, wondering if there is a way to create an array column from the web UI? Normally you would do something like varchar[] but in the web ui there is no array type. Does this have to be done from a client connected to the db? I tried just pasting an array into a text column and it's treated as a string.

[tacit sail]

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

[grave adder]

Project ID: N/A

[drowsy tangle]

you'd want to use something like pgadmin, please don't rely on the plugins data or query features

[stable kettle]

Yep, our UI is pretty rudimentary here. You'd need to use a different GUI

[cyan holly]

Ok, thanks all. I just ended up using the mac terminal and adding it from the command line.

Is there a way to paste an array into the newly created array column, via the GUI. I get the following:

"malformed array literal"

Looks like this also has to be done via terminal or pgadmin?