Editing array type attributes in attribute table

Question

I loaded a PostgreSQL layer in QGIS project. The layer has some array type attributes like integer[].

I'd like to edit these attributes in Attribute Table. But it doesn't work, I could not type any value in the table cell.

I also tried changing the Fields Widget of the attribute but it seem doesn't support multidimensional array value.

Array types are a non-relational extension of PG. Implementing them would be a significant change to the ODBC model used in cursors. It's not really a surprise they're not supported. I suggest you use the relational model and implement the lists as one-to-many tables. — Vince, May 24, 2020 at 14:29
Which version are you using? Editing an integer[] field should work out of the box (QGIS 3.10) — JGH, May 24, 2020 at 17:49
@JGH I am currently using QGIS 3.12.1. I have not done this on QGIS 3.10 before. I may have a try, thanks. — Zipei Lu, May 25, 2020 at 0:58
@Vince Thanks for your explanation. But using one-to-many tables is too complicated for editing features manually. Strange thing is if I export features as a GeoJSON file. The list-like string will automatically convert to list type. If I import the GeoJSON , the list turns to string. They don't support array types may have other reasons other than ODBC model. — Zipei Lu, May 25, 2020 at 2:21

JGH · Accepted Answer · 2020-05-25 11:21:37Z

2

For a table containing an array of integer

 create table testarr(id int primary key, arr integer[], geom geometry(point, 4326));

The widget type should be set to list

You can then edit a current record

or add a new one

answered May 25, 2020 at 11:21

JGH

38.3k3 gold badges38 silver badges85 bronze badges

Yes, this way works, but it doesn't support more than 1 dimension array :(
– Zipei Lu
May 25, 2020 at 13:22

Add a comment |

1 Answer 1