Hi, Please find attached patch to fix malformed sql for data type.
-- *Harshal Dhumal* *Sr. Software Engineer* EnterpriseDB India: http://www.enterprisedb.com The Enterprise PostgreSQL Company
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/types/templates/type/macros/get_full_type_sql_format.macros b/web/pgadmin/browser/server_groups/servers/databases/schemas/types/templates/type/macros/get_full_type_sql_format.macros index 4b9c0e9..c3f7707 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/types/templates/type/macros/get_full_type_sql_format.macros +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/types/templates/type/macros/get_full_type_sql_format.macros @@ -13,7 +13,7 @@ time({{ type_length }}) with time zone{% endif %}{% if is_type_array %} {###### Need to check against separate time types - END ######} {#############################################################} {% else %} -{{ conn|qtTypeIdent(type_name) }}{% if type_length %} +{{ type_name }}{% if type_length %} ({{ type_length }}{% if type_precision%}, {{ type_precision }}{% endif %}){% endif %}{% if is_type_array %} []{% endif %} {% endif %}