Function writeIndexesSDL

backend/plugin/schema/pg/get_database_definition.go:3318–3339

(out io.Writer, schemaName string, table *storepb.TableMetadata)

}

func writeIndexesSDL(out io.Writer, schemaName string, table *storepb.TableMetadata) error {
	if tableMissingColumnMetadata(table) {
		// Indexes would reference columns absent from the dump.
		return nil
	}
	for _, index := range table.Indexes {
		// Skip indexes that are constraints (primary key, unique constraints)
		// These are already handled in the CREATE TABLE statement
		if index.Primary || index.IsConstraint {
			continue
		}

		if err := writeIndexSDL(out, schemaName, table.Name, index, len(table.Partitions) > 0); err != nil {
			return err
		}

		if _, err := io.WriteString(out, ";\n\n"); err != nil {
			return err
		}
	}
	return nil
}

func writeIndexSDL(out io.Writer, schemaName string, tableName string, index *storepb.IndexMetadata, useOnlyClause bool) error {
	return writeIndexInternal(out, schemaName, tableName, index, useOnlyClause, false)