Re: default enconding

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> writes:
> > Hi, I have found what I thing is a quite annoying behaviour of
> > Postgres (psql). When you type (and ask for complation) for some
> > string that has some characters not in the ASCII encoding it requires
> > a double quote on it, however if you don't put those double quotes
> > around it, you can still execute the query.
>
> ... in other words, it doesn't require the double quotes. I don't see
> the value of being more restrictive. Why is this annoying?

It's because you can't complete without the double quote, so,

select something.fo<tab>

doesn't complete if you have only foó as the only completion whereas

select something ."fo

does.

Regards,
Manuel.