From: paulo matadr <saddoness@yahoo.com.br>
To: admin <pgsql-admin@postgresql.org>
Subject: Res: [GENERAL] Res: Cluster with LATIN1 and UTF-8
Date: Mon, 13 Dec 2010 12:38:12 -0800 (PST)
Message-ID: <825780.59847.qm@web114715.mail.gq1.yahoo.com> (raw)
In-Reply-To: <AANLkTikrr8ZstysMFmhw5rHPb9Mgh5v=S9h+oZ=__h7Z@mail.gmail.com>
References: <382634.50728.qm@web114704.mail.gq1.yahoo.com>
<4D063798.2010206@2ndQuadrant.it>
<979244.32654.qm@web114719.mail.gq1.yahoo.com>
<AANLkTikrr8ZstysMFmhw5rHPb9Mgh5v=S9h+oZ=__h7Z@mail.gmail.com>
Solved tnks...
createdb -E LATIN1 -O yyyy -T template0 --lc-collate=pt_BR --lc-ctype=pt_BR xxxx
Paulo
________________________________
De: Osvaldo Kussama <osvaldo.kussama@gmail.com>
Para: paulo matadr <saddoness@yahoo.com.br>
Enviadas: Segunda-feira, 13 de Dezembro de 2010 16:14:36
Assunto: Re: [GENERAL] Res: [ADMIN] Cluster with LATIN1 and UTF-8
2010/12/13 paulo matadr <saddoness@yahoo.com.br>:
> 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@2ndQuadrant.it>
> Para: paulo matadr <saddoness@yahoo.com.br>
> Cc: admin <pgsql-admin@postgresql.org>
> 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.
>
See an example in manual:
http://www.postgresql.org/docs/current/interactive/multibyte.html#AEN30690
Osvaldo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: saddoness@yahoo.com.br
Subject: Re: Res: [GENERAL] Res: Cluster with LATIN1 and UTF-8
In-Reply-To: <825780.59847.qm@web114715.mail.gq1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox