Updating a table with a column name that has a dot (.) on it throws error (relation does not exist)

App Building
1

  • Goal: Updating of a PostgresDB table with the GUI method.

  • Steps: I just simply selected GUI to update a row in a PostgresDB table.

  • Details: I have the correct column names and form data key from the form. It's just this one column that has a dot (.) on it's name that's causing the issue.

Example column name: Est. Date

I'm guessing Retool is parsing it as "Est"."Date" ( as I can see when previewing the SQL statement in the error). Anyway to solve this without using non-GUI method? I've tried both Changeset type ("Key value pairs" and "Object")

Thanks.

2

Hmm, as far as a workaround, I know it works in SQL mode to do a single update like this (with double quotes around the column name): Update table_name set "Est. Date" = 'date here' where id = 'id here'

Otherwise, is it an option to remove the dot? :thinking: