What is the purpose of the keyword “||” in PostgreSQL?
String concatenation as you can see here: http://www.postgresql.org/docs/9.4/static/functions-string.html

Array concatenation: http://www.postgresql.org/docs/9.4/static/functions-array.html

And others... It means: concatenation.