New/Custom DataType - Altering definition / seeing definition in pgAdmin3 - Mailing list pgsql-general

I've created a new custom datatype

eg:

create type foo as (
id smallint
data1 int
data2 int
)

to view the datatype in psql I do
=> \d foo

what is the equilvalent on pgadmin3 or any other SQL query tool?


As i understand from the docs, I can't alter / change the datatype
definition. If I need to change it, I need to drop it and re-create it
again. Correct me if I'm wrong.