Concatenate 2 fields

To Concatenate 2 fields in postgres, simply use the || operator.

ie select first_name||last_name from names;