Re: no value in string

stev knowles <stev(at)Precision(dot)Guesswork(dot)COM> writes:
> so, it appears that my empty strings are really strings with a single blank
> space. how can i stop that from happening when i load the data in? is there
> some way to declare the datum so that blank values are not turned into a
> space?

PG is certainly not doing that to you (unless perhaps you are talking
about a char(1) column). You need to look for the cause in your
client-side code.

If you are asking for a way to defend against client-side brain death,
perhaps a constraint on the order of CHECK (foo != ' ') would do.

regards, tom lane