Switch to: V11V10V9V8V7V6V5

Data Editor - Array Editor

The Valentina Studio Data Editor allows you to view and edit values of the array field type in Valentina (supported in 8.x and later) and PostgreSQL databases.

The Array Editor is a specialized tool for creating and modifying the content of an array field in your database.

The user experience for ValentinaDB and PostgreSQL appear different from each other because of the unique ways in which arrays work in each database.

Array Editor - Valentina

Values of the array field are shown in square brackets.

Double-click the cell or use a small button below it to open an editor in popup:

It can also be edited in the modal dialog, you can use the Content Editor button below the grid to activate it.

It has the following controls:

  • Values line edits – edit individual array elements.
  • NULL buttons – to set NULL value for individual element.
  • Set NULL button – sets the NULL value as the array field value.
  • Change button – apply changes made in the dialog.

Array Editor - PostgreSQL

The values of the array field are shown in curly brackets. They can be edited in the inline editor:

Double-click the cell to open the array editor:

It has the following controls:

  • Values grid.
  • NULL button – to set NULL value for individual element.
  • Dimensions field – definition of the array value. Each dimension is represented with a pair of square brackets. The number of elements in each dimension is the number in the brackets.
  • Set NULL button – sets the NULL value as the array field value.
  • Change button – apply changes made in the dialog.

If the number of dimensions is bigger than 2, it is necessary to go to a deeper level with a double click:

Arrays with 1 and 2 dimensions: