duckweb_cookie

scalar · LOAD duckweb

duckweb_cookie(VARCHAR, VARCHAR) -> VARCHAR

Reads one cookie out of a Cookie header value.

duckweb_cookie(duckweb_header_value(headers, 'Cookie'), 'theme')

Takes the header value, not the whole header block — pair it with duckweb_header_value.

The value is percent-decoded, matching duckweb_set_cookie, which encodes it. A cookie that is not there reads as the empty string.

A pair with no = is skipped rather than ending the search: browsers serialise document.cookie = "flag" as exactly that, and giving up there would hide every cookie after it.