"Zoltan Kovacs" <kovzol@particio.com> writes:
> I would like to create a database using SQL_ASCII encoding, but it is not
> allowed for a normal user, only for the postgres user.
There is an exception that will allow superusers to do that, but it's
not a good idea for them either. The problem is not the encoding per
se, it's that it's unsafe in combination with a locale setting that
assumes UTF8. The only safe locale for SQL_ASCII is C.
If you want to have one database that is C/SQL_ASCII and others that
have different locale settings, you need to upgrade to PG 8.4. 8.3
can only have one locale across the entire installation.
regards, tom lane