Method escapeDataTypeName

database/postgres/database.go:1082–1119

escapeDataTypeName quotes a data type name appropriately. Handles array types and schema-qualified names. Uses case detection to determine if quoting is needed: - All lowercase names (built-in types or unquoted custom types) are not quoted - Names with uppercase letters (quoted custom types) are quo

(typeName string)

//   - All lowercase names (built-in types or unquoted custom types) are not quoted
//   - Names with uppercase letters (quoted custom types) are quoted to preserve case
func (d *PostgresDatabase) escapeDataTypeName(typeName string) string {
	// Handle array types: preserve the [] suffix
	arraySuffix := ""
	if strings.HasSuffix(typeName, "[]") {
		arraySuffix = "[]"
		typeName = strings.TrimSuffix(typeName, "[]")
	}

	// If already quoted (from format_type()), return as-is
	if strings.HasPrefix(typeName, "\"") && strings.HasSuffix(typeName, "\"") {
		return typeName + arraySuffix
	}

	// Handle schema-qualified types (e.g., "public.my_type")
	if idx := strings.Index(typeName, "."); idx > 0 {
		schema := typeName[:idx]
		baseType := typeName[idx+1:]
		// Quote each part only if it has uppercase letters
		escapedSchema := schema
		if strings.ToLower(schema) != schema {
			escapedSchema = d.quoteIdentifierIfNeeded(schema)
		}
		escapedType := baseType
		if strings.ToLower(baseType) != baseType {
			escapedType = d.quoteIdentifierIfNeeded(baseType)
		}
		return escapedSchema + "." + escapedType + arraySuffix
	}

	// For simple type names, use case detection:
	// - All lowercase: don't quote (built-in types like "integer", or custom types created without quotes)
	// - Has uppercase: quote to preserve case (custom types created with quotes like "UserStatus")
	if strings.ToLower(typeName) == typeName {
		return typeName + arraySuffix
	}

	return d.quoteIdentifierIfNeeded(typeName) + arraySuffix
}

func splitTableName(table string, defaultSchema string) (string, string) {
	schema := defaultSchema