Function PostgresNodeFormatter

testing/go/enginetest/query_converter_test.go:1249–1313

(buf *sqlparser.TrackedBuffer, node sqlparser.SQLNode)

}

func PostgresNodeFormatter(buf *sqlparser.TrackedBuffer, node sqlparser.SQLNode) {
	switch node := node.(type) {
	case sqlparser.ColIdent:
		// MySQL `@var` and `@@var` references map to postgres' current_setting().
		// All other identifiers go through tree.AutoQuoteIdent so that names
		// containing special characters or matching a reserved keyword come out
		// double-quoted (postgres' quoting style) rather than backticked
		// (vitess' default formatID behavior).
		switch {
		case strings.HasPrefix(node.String(), "@@"):
			buf.Myprintf("current_setting('.%s')", strings.TrimLeft(node.String(), "@"))
		case strings.HasPrefix(node.String(), "@"):
			buf.Myprintf("current_setting('doltgres_enginetest.%s')", strings.TrimLeft(node.String(), "@"))
		default:
			buf.WriteString(AutoQuoteIdent(node.Lowered()))
		}
	case sqlparser.TableIdent:
		// Same auto-quoting story as ColIdent; vitess' formatID would
		// otherwise wrap special-character identifiers in backticks.
		buf.WriteString(AutoQuoteIdent(node.String()))
	case sqlparser.TableName:
		// MySQL `db.tbl` → postgres `db.public.tbl`. MySQL has no schema
		// concept, so we insert `public` (postgres' default schema) between
		// the catalog and table when a database qualifier is present —
		// except for well-known schemas like `information_schema`, where the
		// MySQL qualifier already lines up with a postgres schema.
		switch {
		case node.DbQualifier.IsEmpty():
			buf.Myprintf("%v", node.Name)
		case isWellKnownSchema(node.DbQualifier.String()):
			buf.Myprintf("%v.%v", node.DbQualifier, node.Name)
		default:
			buf.Myprintf("%v.public.%v", node.DbQualifier, node.Name)
		}
	case *sqlparser.ColName:
		// Same translation for qualified column references: `db.tbl.col` →
		// `db.public.tbl.col`, leaving `information_schema.tbl.col` alone.
		switch {
		case node.Qualifier.DbQualifier.IsEmpty() && node.Qualifier.Name.IsEmpty():
			buf.Myprintf("%v", node.Name)
		case node.Qualifier.DbQualifier.IsEmpty():
			buf.Myprintf("%v.%v", node.Qualifier.Name, node.Name)
		case isWellKnownSchema(node.Qualifier.DbQualifier.String()):
			buf.Myprintf("%v.%v.%v", node.Qualifier.DbQualifier, node.Qualifier.Name, node.Name)
		default:
			buf.Myprintf("%v.public.%v.%v", node.Qualifier.DbQualifier, node.Qualifier.Name, node.Name)
		}
	case *sqlparser.UnaryExpr:
		if node.Operator == "binary " {
			buf.Myprintf("%v::text::bytea", node.Expr)
		} else {
			buf.Myprintf("%v", node)
		}
	case *sqlparser.Limit:
		if node == nil {
			return
		}
		buf.Myprintf(" limit %v", node.Rowcount)