PostgreSQL array column creation from web ui?
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.
5 Replies
Project ID:
N/Ayou'd want to use something like pgadmin, please don't rely on the plugins data or query features
Yep, our UI is pretty rudimentary here. You'd need to use a different GUI
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?
yep