All text between $$ (anonymous or named i.e. $name$) code highlighted as text literal. E.g. standard example from official PG docs:

CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
AS $$
INSERT INTO tbl VALUES (a);
INSERT INTO tbl VALUES (b);
$$;

All text from $$ to $$ is colored as literal.