In PostgreSQL we can use the array_dims()
function to return information about the dimensions in an array. The function accepts the array in question, and it returns a text representation of the array’s dimensions.
This function is not to be confused with the array_ndims()
function, which simply returns the number of dimensions in an array.