Res: [ADMIN] Cluster with LATIN1 and UTF-8

[paulo matadr <saddoness@xxxxxxxxxxxx>]

I dont find way to create cluster... with example:
 psql -l 
teste1                           |admin                       | LATIN1
teste2                           | postgres                  | SQL_ASCII
teste3                           | admin2                    | UTF8

-bash-3.1$ psql --version
psql (PostgreSQL) 8.3.5
on this version in another server, it's working..
but I cant repeat on postgres 9 .

 

Paulo

---

De: Gabriele Bartolini <gabriele.bartolini@xxxxxxxxxxxxxx>
Para: paulo matadr <saddoness@xxxxxxxxxxxx>
Cc: admin <pgsql-admin@xxxxxxxxxxxxxx>
Enviadas: Segunda-feira, 13 de Dezembro de 2010 13:11:20
Assunto: Re: [ADMIN] Cluster with LATIN1 and UTF-8

Ciao Paulo,

Il 13/12/10 14:22, paulo matadr ha scritto:

Im try install postgres 9.0  on rhel
and I try install cluster with 2 options of databases  LATIN1 and UTF-8.
It's possible?

Yes it is. I suggest that you look at the "ENCODING" option for the CREATE DATABASE command:

http://www.postgresql.org/docs/9.0/interactive/sql-createdatabase.html

Hope this helps.

Cheers,
Gabriele

-- 
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 gabriele.bartolini@xxxxxxxxxxxxxx | www.2ndQuadrant.it