Skip to content

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