Function writeViewSDL

backend/plugin/schema/pg/get_database_definition.go:3430–3458

(out io.Writer, schemaName string, view *storepb.ViewMetadata)

}

func writeViewSDL(out io.Writer, schemaName string, view *storepb.ViewMetadata) error {
	if _, err := io.WriteString(out, `CREATE VIEW "`); err != nil {
		return err
	}

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

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

	if _, err := io.WriteString(out, view.Name); err != nil {
		return err
	}

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

	// The view definition should already include the SELECT statement
	definition := strings.TrimSpace(view.Definition)
	// Remove trailing semicolon if present
	definition = strings.TrimSuffix(definition, ";")

	_, err := io.WriteString(out, definition)
	return err
}

func writeMaterializedViewSDL(out io.Writer, schemaName string, view *storepb.MaterializedViewMetadata) error {
	if _, err := io.WriteString(out, `CREATE MATERIALIZED VIEW "`); err != nil {