"Huy Do" <huy(at)travel(dot)com(dot)au> writes:
> 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.
Postgres does not trim trailing spaces. I suspect that that behavior
is coming from whatever tool you used to transfer the data.
regards, tom lane