Skip site navigation (1) Skip section navigation (2)

Data type display

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Data type display
Date: 2006-01-31 11:02:35
Message-ID: 200601311202.35771.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgadmin-hackers
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/

Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2006-01-31 11:03:56
Subject: Re: GrantWizard Property Crack?
Previous:From: Hiroshi SaitoDate: 2006-01-31 08:14:57
Subject: GrantWizard Property Crack?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group