Function buildCreateStmt

backend/plugin/parser/pg/query_span_loader_builders.go:37–64

buildCreateStmt translates TableMetadata into a CreateStmt with real column types. Column types are parsed via typeNameFromString; an error on any single column propagates back so the loader can pseudo the whole relation rather than install a partially-typed catalog entry. Columns with empty names

(schema string, table *storepb.TableMetadata)

//
// Columns with empty names are skipped.
func buildCreateStmt(schema string, table *storepb.TableMetadata) (*ast.CreateStmt, error) {
	items := make([]ast.Node, 0, len(table.Columns))
	for _, col := range table.Columns {
		if col.Name == "" {
			continue
		}
		if col.Type == "" {
			return nil, errors.Errorf("column %q: empty type", col.Name)
		}
		tn, err := typeNameFromString(col.Type)
		if err != nil {
			return nil, errors.Wrapf(err, "column %q", col.Name)
		}
		items = append(items, &ast.ColumnDef{
			Colname:   col.Name,
			TypeName:  tn,
			IsNotNull: !col.Nullable,
		})
	}
	return &ast.CreateStmt{
		Relation: &ast.RangeVar{
			Schemaname:     schema,
			Relname:        table.Name,
			Relpersistence: 'p',
		},
		TableElts: &ast.List{Items: items},
	}, nil
}

// buildViewStmt translates ViewMetadata into a ViewStmt. The view body is
// parsed via ParsePg; the result must be a *ast.SelectStmt (not a RawStmt