Find replace in Postgresql

data.csv

excel-formula.txt

// Put this formula in column C2 and drag down to prepend the letter `a` in front of the contents of column B2
// Excel requires double quotes

=CONCATENATE("a", B2)

find-replace.sql

-- Docs http://www.postgresql.org/docs/current/static/functions-string.html
-- Postgresql requires single quotes.

-- Generic template

UPDATE your-table-name SET your-column-name = REPLACE(your-column-name, 'string-to-replace', 'what-to-replace-it-with');

-- Example. Your table is called `my_table`, column is called `fips` and you've prepended an `a` before each value to maintain its identity as a string and now you want to remove it

UPDATE my_table SET fips = REPLACE(fips, 'a', '');

-- Better example. Add a new column called `clean_fips` so you can compare the results against the old. You can create a new column via the CartoDB interface.

UPDATE my_table SET clean_fips = REPLACE(fips, 'a', '');