I have this insert select statement, copying data from employee bulk add staging to employee table: Even if I change it to RTRIM or REPLACE(eb.tr_email, ‘ ‘, ”) to replace the spaces with nothing it will still not modify the data to be inserted. I cannot get my login to work since my backend application detects these trailing white spaces
Tag: whitespace
How to show leading/trailing whitespace in a PostgreSQL column?
I can’t see leading/trailing whitespace in the following following SQL statement executed with psql: Is there a pragmatic way to see leading/trailing whitespace? Answer If you don’t mind substituting all whitespace characters whether or not they are leading/trailing, something like the following will do it: This is using an underscore to mark the spaces but of course you are free