Insert any type of text in a column
You are not limited to just $$ you can use anything enclosed in $, e.g. $_alex_delimiter_$

insert into foo 
   (some_column)
values
  ($_alex_delimiter_$this is a long string that contains a single $ and two $$ and quotes '''''$_alex_delimiter_$);


Just pick something that won't be part of the text.