Multiselect for PostgreSQL array in Base form?

asked 2016-03-01 20:48:53 +0100

Aram Fingal gravatar image

I have a LibreOffice Base file which is connecting to a PostgreSQL 9.5 database. There is a form for data entry to a single table and one of the fields in that table is defined as an array of text in PostgreSQL. At the moment, I have the input to this field configured as a combo box with the multiselect option set to "yes." However, the user is not able to select more than one item from the combo box but they can select one item and then manually type additional elements for the array (if they get the curly brackets and commas correct.) So this works but it's not ideal. Is there some way that I can set things up so that the user can just select multiple items from a list to populate the array or are PostgreSQL arrays just not supported in LibreOffice?

edit retag flag offensive close merge delete