Data type display

Is there a reason why pgAdmin uses internal type names like int2 everywhere,
whereas the supposedly user-friendly approach would be that external names
like smallint should be used.  (Compare to the output of psql and pg_dump.)
You can obtain the friendly name using the backend function format_type,
which has been available at least since 7.3.  This would also avoid the need
for manual concatenating with "[]" for array types.

Also, the lists of data types you get when creating a table are not sorted
very well.  The beginning seems to be alphabetical, but the geometry types
are at the end.

Perhaps, as an interface improvement, remove all the array types from the list
but instead make a separate checkbox "Array" instead.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/