pgEdit supports PostgreSQL specific syntax coloring (e.g. dollar quoting), SQL execution, context specific help, completion, and recognition of SQL language constructs (tables, functions, triggers, etc.). pgEdit uses psql for executing SQL and takes advantage of many psql features. See the "pgEdit Help" command for more details.
If you are interested in PostgreSQL, please give it a try and send me your feedback.
http://pgedit.com/public/beta/pgEdit_TextMate_2.0b1.zip
John DeSoi, Ph.D.