Обсуждение: Numeric type

Hi,
 Where I live, We have a numeric like ####,### , but postgres default 
is a dot (like ####.###).
How can I change that??? A change my locale (to pt_BR) and restarted 
postgreql, but it didn work....

Any Help?

Alan Roberto Romaniuc <romaniuc@klais.com.br> writes:
>   Where I live, We have a numeric like ####,### , but postgres default 
> is a dot (like ####.###).
> How can I change that?

I believe the output of to_char() is locale-dependent.  The regular
display is not (and shouldn't be, IMHO, because it would make
dump/reload too chancy).
        regards, tom lane