Hi,
Is there a way to get postgres to keep the trailing spaces
in a field. I have an existing database which I am porting
to postgresql. This database allows fields to have trailing
spaces and many key fields have trailing spaces to distinguish
uniqueness (i know this is bad but it's legacy stuff).
When I dump my database and try to copy it into postgresql, it
complains about duplicate keys because postgres is trimming the
spaces.
Can anyone help ?
Thanks so much
Huy