title: Append text to column data based on the column in PostgreSQL
body: <p>I would like to append some text to every cell in each column of my table to act as a symbol for that particular column. For example say my table is as follows (all fields are type character varying):</p>
  
  <pre>
  name    age    location
  james   45     france
  simon   33     usa
  ben     76     china
  </pre>
  
  <p>I would like to modify it to be:</p>
  
  <pre>
  name    age    location
  ajames   b45     cfrance
  asimon   b33     cusa
  aben     b76     cchina
  </pre>
  
  <p>Does anyone have any suggestions as to how I can do this?</p>