I inserted data onto my table, but I realized that some values are correct and have leading spaces. So essentially I would need to change "Austin " to "Austin" for a whole column.
How would I go about mass updating all of the values of a column in my Retool table?
You could write an UPDATE query, and you could do it a couple of ways...assume for the following that the name of your table is table_name and your column is column_name (replace them with the right value when you actually use the queries)
If you specifically and only want to address "Austin ":
UPDATE table_name
SET column_name = 'Austin'
WHERE column_name = 'Austin '
Or if you want to eliminate trailing spaces anywhere in the that column:
UPDATE table_name
SET column_name = rtrim(column_name)
Or if you want to eliminate leading spaces anywhere in the that column:
UPDATE table_name
SET column_name = ltrim(column_name)
Or if you want to eliminate leading & trailing spaces anywhere in the that column:
UPDATE table_name
SET column_name = trim(column_name)
You can actually use trim ( [ LEADING | TRAILING | BOTH ] [ characters text ] FROM string text ) to do all of the above as well (see PostgreSQL string functions here)