pgEdit

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

• pgEdit has been updated to work with TextMate 2.
• The syntax highlighting grammar now supports all PostgreSQL 9.3 keywords and SQL commands.
• This update also includes other minor fixes and improvements related to syntax highlighting, completion, and dropping SQL objects.