Function buildSessionPgSequencesViewSQL

server/sessionmeta/sessionmeta.go:613–636

buildSessionPgSequencesViewSQL builds the catalog-scoped pg_catalog.pg_sequences compat view (same cross-catalog-leak rationale as buildSessionPgTablesViewSQL). Sources duckdb_sequences() filtered to current_database(). Column names and types mirror DuckDB's native pg_sequences (the view these queri

()

				a.attcacheoff,
				CASE
					WHEN (dc.data_type LIKE 'DECIMAL%%' OR dc.data_type LIKE 'NUMERIC%%') AND a.atttypmod > 0 THEN
						(((a.atttypmod / 1000)::INTEGER << 16) | ((a.atttypmod %% 1000)::INTEGER + 4))::INTEGER
					ELSE a.atttypmod
				END AS atttypmod,
				a.attbyval,
				a.attalign,
				a.attstorage,
				a.attcompression,
				a.attnotnull,
				a.atthasdef,
				a.atthasmissing,
				a.attidentity,
				a.attgenerated,
				a.attisdropped,
				a.attislocal,
				a.attinhcount::INTEGER AS attinhcount,
				a.attcollation::UINTEGER AS attcollation,
				a.attacl,
				a.attoptions,
				a.attfdwoptions,
				a.attmissingval
		FROM pg_catalog.pg_attribute a
		JOIN main.pg_class_full c ON c.oid = a.attrelid
		JOIN main.pg_namespace n ON n.oid = c.relnamespace
		LEFT JOIN duckdb_columns() dc ON dc.table_oid = a.attrelid AND dc.column_name = a.attname
	`, nativeTypeOID)
}