Function writeSequenceSDL

backend/plugin/schema/pg/get_database_definition.go:3500–3560

(out io.Writer, schemaName string, sequence *storepb.SequenceMetadata)

}

func writeSequenceSDL(out io.Writer, schemaName string, sequence *storepb.SequenceMetadata) error {
	// Write CREATE SEQUENCE statement with schema and name
	if _, err := fmt.Fprintf(out, "CREATE SEQUENCE \"%s\".\"%s\"", schemaName, sequence.Name); err != nil {
		return err
	}

	// Add data type (always output for consistency with non-SDL format)
	if sequence.DataType != "" {
		if _, err := fmt.Fprintf(out, " AS %s", sequence.DataType); err != nil {
			return err
		}
	}

	// Add START WITH (always output for consistency with non-SDL format)
	if sequence.Start != "" {
		if _, err := fmt.Fprintf(out, " START WITH %s", sequence.Start); err != nil {
			return err
		}
	}

	// Add INCREMENT BY (always output for consistency with non-SDL format)
	if sequence.Increment != "" {
		if _, err := fmt.Fprintf(out, " INCREMENT BY %s", sequence.Increment); err != nil {
			return err
		}
	}

	// Add MINVALUE (always output for consistency with non-SDL format)
	if sequence.MinValue != "" {
		if _, err := fmt.Fprintf(out, " MINVALUE %s", sequence.MinValue); err != nil {
			return err
		}
	}

	// Add MAXVALUE (always output for consistency with non-SDL format)
	if sequence.MaxValue != "" {
		if _, err := fmt.Fprintf(out, " MAXVALUE %s", sequence.MaxValue); err != nil {
			return err
		}
	}

	// Add CYCLE/NO CYCLE (always output for consistency with non-SDL format)
	if sequence.Cycle {
		if _, err := io.WriteString(out, " CYCLE"); err != nil {
			return err
		}
	} else {
		if _, err := io.WriteString(out, " NO CYCLE"); err != nil {
			return err
		}
	}

	// Add CACHE (new field to match non-SDL format)
	if sequence.CacheSize != "" {
		if _, err := fmt.Fprintf(out, " CACHE %s", sequence.CacheSize); err != nil {
			return err
		}
	}