ERROR: could not find array type for datatype information_schema.sql_identifier I am trying to run the below sql command:

SELECT ARRAY(
    SELECT column_name 
    FROM information_schema.columns 
    WHERE table_name ='gis_field_configuration_stage'
);


and I get the below error:

ERROR:  could not find array type for datatype information_schema.sql_identifier
Just cast column_name to text to bypass the error:

SELECT ARRAY(
    SELECT column_name::text
    FROM information_schema.columns 
    WHERE table_name ='gis_field_configuration_stage'
);


Its original type is information_schema.sql_identifier and its happens that an array of that type is not provided in the predefined types.