it always returns Character Varying or whatever, it would be nice if it had a option to return a short version of
these names. i.e.
format_type(a.atttypid, a.atttypmod,true) would return all short names
format_type(a.atttypid, a.atttypmod,false) would return full names
I don't know of any other system that shows varchars in this way, they should just be formated as varchar(50).
If there is another way to do this without messy case statements please let me know.
Thanks,
Tony
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
