Data type display

[Peter Eisentraut <peter_e(at)gmx(dot)net>]

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/