Function buildSessionPgTablesViewSQL

server/sessionmeta/sessionmeta.go:558–579

buildSessionPgTablesViewSQL builds the catalog-scoped pg_catalog.pg_tables compat view. DuckDB's native pg_tables spans EVERY attached catalog and ignores current_database(), so on a multi-catalog worker a bare pg_tables would leak another catalog's table names into the session. This view sources du

()

		WHEN {dt} = 'SMALLINT' THEN 21::UINTEGER
		WHEN {dt} = 'TINYINT' THEN 21::UINTEGER
		WHEN {dt} = 'HUGEINT' THEN 1700::UINTEGER
		WHEN {dt} = 'UBIGINT' THEN 1700::UINTEGER
		WHEN {dt} = 'UINTEGER' THEN 20::UINTEGER
		WHEN {dt} = 'USMALLINT' THEN 23::UINTEGER
		WHEN {dt} = 'UTINYINT' THEN 21::UINTEGER
		WHEN {dt} = 'FLOAT' OR {dt} = 'DOUBLE' THEN 701::UINTEGER
		WHEN {dt} = 'REAL' THEN 700::UINTEGER
		WHEN {dt} = 'VARCHAR' THEN 1043::UINTEGER
		WHEN {dt} = 'TEXT' THEN 25::UINTEGER
		WHEN {dt} = 'CHAR' OR {dt} = 'BPCHAR' THEN 1042::UINTEGER
		WHEN {dt} = 'BOOLEAN' THEN 16::UINTEGER
		WHEN {dt} = 'BLOB' OR {dt} = 'BYTEA' THEN 17::UINTEGER
		WHEN {dt} = 'DATE' THEN 1082::UINTEGER
		WHEN {dt} = 'TIME' THEN 1083::UINTEGER
		WHEN {dt} = 'TIMESTAMP' THEN 1114::UINTEGER
		WHEN {dt} LIKE 'TIMESTAMP WITH TIME ZONE%' THEN 1184::UINTEGER
		WHEN {dt} LIKE 'TIME WITH TIME ZONE%' THEN 1266::UINTEGER
		WHEN {dt} = 'INTERVAL' THEN 1186::UINTEGER
		WHEN {dt} = 'UUID' THEN 2950::UINTEGER
		WHEN {dt} = 'BIT' THEN 1560::UINTEGER
		WHEN {dt} = 'JSON' THEN 114::UINTEGER
		WHEN {dt} = 'INTEGER[]' THEN 1007::UINTEGER
		WHEN {dt} = 'BIGINT[]' THEN 1016::UINTEGER
		WHEN {dt} = 'SMALLINT[]' THEN 1005::UINTEGER
		WHEN {dt} = 'VARCHAR[]' THEN 1015::UINTEGER