I work in the program PgAdmin. There is an array of data, you need to know how many values ​​are in the array

SELECT id, firstname, lastname, phonenumber, COUNT(languages) FROM person GROUP BY 1

Through COUNT (languages) displays only the number 1, although the values ​​in the array more

    1 answer 1

     SELECT firstname, lastname, phonenumber, array_length(languages, <измерение массива>), -- длина по конкретному измерению cardinality(languages) -- длина по всем измерениям FROM person

    read more: https://postgrespro.ru/docs/postgrespro/9.6/arrays