Newby Question - the function replace is throwing a syntax error

[jillmonetmason]

Hi There,
I'm new to metabase, running Postgres and can not get any functions to run.

I'm currently trying:
select name, replace([name],"The","") from properties where id = 152184

Getting the error:
ERROR: syntax error at or near "[" Position: 142

See this image:

[Luiggi]

replace [name] for {{name}}