Method SQL

pkg/sql/ast/sql.go:778–822

SQL returns the full SQL string for this CREATE TABLE statement including column definitions, table constraints, INHERITS, PARTITION BY, and table options.

()

// SQL returns the full SQL string for this CREATE TABLE statement including
// column definitions, table constraints, INHERITS, PARTITION BY, and table options.
func (c *CreateTableStatement) SQL() string {
	if c == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)
	sb.WriteString("CREATE ")
	if c.Temporary {
		sb.WriteString("TEMPORARY ")
	}
	sb.WriteString("TABLE ")
	if c.IfNotExists {
		sb.WriteString("IF NOT EXISTS ")
	}
	sb.WriteString(c.Name)
	sb.WriteString(" (")

	parts := make([]string, 0, len(c.Columns)+len(c.Constraints))
	for _, col := range c.Columns {
		col := col // G601: Create local copy to avoid memory aliasing
		parts = append(parts, columnDefSQL(&col))
	}
	for _, con := range c.Constraints {
		con := con // G601: Create local copy to avoid memory aliasing
		parts = append(parts, tableConstraintSQL(&con))
	}
	sb.WriteString(strings.Join(parts, ", "))
	sb.WriteString(")")

	if len(c.Inherits) > 0 {
		sb.WriteString(" INHERITS (")
		sb.WriteString(strings.Join(c.Inherits, ", "))
		sb.WriteString(")")
	}

	if c.PartitionBy != nil {
		fmt.Fprintf(sb, " PARTITION BY %s (%s)", c.PartitionBy.Type, strings.Join(c.PartitionBy.Columns, ", "))
	}

	for _, opt := range c.Options {
		fmt.Fprintf(sb, " %s=%s", opt.Name, opt.Value)
	}

	return sb.String()
}

// SQL returns the full SQL string for this CREATE INDEX statement including
// the UNIQUE modifier, IF NOT EXISTS, USING method, column list, and WHERE predicate.