Trailing spaces in char or varchar fields - Mailing list pgsql-novice

From Huy Do
Subject Trailing spaces in char or varchar fields
Date
Msg-id NEBBIHDFCLBAILBDEADCIEDKCAAA.huy@travel.com.au
Whole thread Raw
In response to 7.0.2: missing CREATE DATABASE documentation  ("Albert REINER" <areiner@tph.tuwien.ac.at>)
Responses Re: Trailing spaces in char or varchar fields
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Thomas SMETS
Date:
Subject: Casting
Next
From: Thomas SMETS
Date:
Subject: Debugging ?