Additionally I have shifted 'Advanced tab' after columns & constraint tab.
@Thom,
Reading "Of type" drop-down, We borrowed sql query from pgadmin3 to populate "Of type" combo box as given below.
I was not able to find a way to differentiate between table & composite type populating from below given query,
I'll put in todo list, may be someone from community can help in future.
SELECT t.oid,
quote_ident(n.nspname)||'.'||quote_ident(t.typname) AS typname
FROM pg_type t, pg_namespace n
WHERE t.typtype='c' AND t.typnamespace=n.oid
AND NOT (n.nspname like 'pg_%' OR n.nspname='information_schema')
ORDER BY typname;
This should work:
SELECT c.oid, quote_ident(n.nspname)||'.'||quote_ident(c.relname) AS typname FROM pg_namespace n, pg_class c WHERE c.relkind = 'c' AND c.relnamespace=n.oid
AND NOT (n.nspname like 'pg_%' OR n.nspname='information_schema') ORDER BY typname;
Although, to avoid confusion, the "typname" alias should probably just be "relname".