Function buildSessionPgViewsViewSQL

server/sessionmeta/sessionmeta.go:586–604

buildSessionPgViewsViewSQL builds the catalog-scoped pg_catalog.pg_views compat view (same cross-catalog-leak rationale as buildSessionPgTablesViewSQL). Sources duckdb_views() filtered to current_database(); the compat views themselves live in memory.main and are excluded by name so a memory-catalog

()

		WHEN {dt} = 'BOOLEAN[]' THEN 1000::UINTEGER
		WHEN {dt} = 'FLOAT[]' OR {dt} = 'DOUBLE[]' THEN 1022::UINTEGER
		WHEN {dt} = 'REAL[]' THEN 1021::UINTEGER
		WHEN {dt} = 'DATE[]' THEN 1182::UINTEGER
		WHEN {dt} = 'TIMESTAMP[]' THEN 1115::UINTEGER
		WHEN {dt} LIKE 'NUMERIC%[]' OR {dt} LIKE 'DECIMAL%[]' THEN 1231::UINTEGER
		WHEN {dt} = 'UUID[]' THEN 2951::UINTEGER
		WHEN {dt} = 'INTERVAL[]' THEN 1187::UINTEGER
		WHEN {dt} = 'BLOB[]' OR {dt} = 'BYTEA[]' THEN 1001::UINTEGER
		WHEN {dt} LIKE 'STRUCT%' THEN 2249::UINTEGER
		ELSE {fallback}::UINTEGER
	END`
	return strings.NewReplacer("{dt}", dataTypeExpr, "{fallback}", fallbackExpr).Replace(template)
}

func buildSessionPgAttributeViewSQL() string {
	nativeTypeOID := pgTypeOIDCaseSQL("UPPER(dc.data_type)", "a.atttypid")
	return fmt.Sprintf(`
		CREATE OR REPLACE VIEW main.pg_attribute AS
		SELECT
				a.attrelid::UINTEGER AS attrelid,
				a.attname,
				%s AS atttypid,
				a.attstattarget,