I got tired of this:
psql:lib/sql/similarity.sql:97: ERROR: column o.user_id does not
exist at character 426
So I wrote this:
https://github.com/jaylevitt/find_psql_error
And you call it like this:
find_psql_error "psql:lib/sql/similarity.sql:97: ERROR: column
o.user_id does not exist at character 426"
Enjoy. Suggestions welcome. Requires Ruby 1.9.