The following bug has been logged online:
Bug reference: 5499
Logged by: Curtis Stecke
Email address: cstecke@interlegis.com
PostgreSQL version: 8.4
Operating system: Windows Xp
Description: SQL syntax bug
Details:
Inserting text that starts with or ends with a dollar sign ($) is
impossible. Documentation is not clear on how to do this as well.