From rodrigo.sakai@zanthus.com.br Tue May 2 14:02:15 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 91FEC9FA3B2 for ; Tue, 2 May 2006 11:02:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 63774-10 for ; Tue, 2 May 2006 11:02:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.zanthus.com.br (mail.zanthus.com.br [200.212.65.85]) by postgresql.org (Postfix) with ESMTP id BE4ED9FA25D for ; Tue, 2 May 2006 11:02:01 -0300 (ADT) Received: from cprsakai ([192.168.0.71]) by mail.zanthus.com.br (8.13.4/8.13.4/Debian-3) with SMTP id k42E42Is020614 for ; Tue, 2 May 2006 11:04:02 -0300 Message-ID: <002501c66df1$23399500$4700a8c0@TREEZANTHUS> Reply-To: "Rodrigo Sakai" From: "Rodrigo Sakai" To: Subject: Modifying the encoding of a database Date: Tue, 2 May 2006 11:03:06 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0022_01C66DD7.FD7ECE20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-Zanthus-MailScanner: Found to be clean X-Zanthus-MailScanner-From: rodrigo.sakai@zanthus.com.br X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.407 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200605/14 X-Sequence-Number: 21546 This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C66DD7.FD7ECE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is it possible to modify the encoding of a production database? Or the = only way is to create a new database with the correct enconding??? Thanks! ------=_NextPart_000_0022_01C66DD7.FD7ECE20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
  Hi,
 
  Is it possible to modify the = encoding of a=20 production database? Or the only way is to create a new database with = the=20 correct enconding???
 
  = Thanks!
------=_NextPart_000_0022_01C66DD7.FD7ECE20-- From shoaibmir@gmail.com Tue May 2 14:07:42 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7E9159FB1CF for ; Tue, 2 May 2006 11:07:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05577-08 for ; Tue, 2 May 2006 11:07:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.204]) by postgresql.org (Postfix) with ESMTP id 49EF79FA25D for ; Tue, 2 May 2006 11:07:30 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id m7so2731978nzf for ; Tue, 02 May 2006 07:07:28 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=puMfenDBMJoGWyMK2smPA+e9LmcA37TND47HaIFrAde0vA3q1myJYCFbigrepubJNhv68YhXzw8cF8lo68VxXsPrWrqf2H1dxbPOVGgOSozSLZnh0MMkFVnmxQLNCZK+scbSQgolSuSe7C3Kdfr1mT+TdXRU2et2EOcFjFvlg1w= Received: by 10.65.150.15 with SMTP id c15mr406383qbo; Tue, 02 May 2006 07:07:27 -0700 (PDT) Received: by 10.65.249.3 with HTTP; Tue, 2 May 2006 07:07:27 -0700 (PDT) Message-ID: Date: Tue, 2 May 2006 19:07:27 +0500 From: "Shoaib Mir" To: pgsql-admin@postgresql.org Subject: Re: Modifying the encoding of a database In-Reply-To: <002501c66df1$23399500$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_34569_19791327.1146578847177" References: <002501c66df1$23399500$4700a8c0@TREEZANTHUS> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/16 X-Sequence-Number: 21548 ------=_Part_34569_19791327.1146578847177 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I dont think so you can modify the database encoding ... solution would be recreate it with the changed encoding /Shoaib On 5/2/06, Rodrigo Sakai wrote: > > Hi, > > Is it possible to modify the encoding of a production database? Or the > only way is to create a new database with the correct enconding??? > > Thanks! > ------=_Part_34569_19791327.1146578847177 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I dont think so you can modify the database encoding ... solution would be = recreate it with the changed encoding

/Shoaib

On 5/2/06, Rodrigo Sakai <rodrigo.sakai@zanthus.com.br> wrote:
  Hi,
 
  Is it possible to modify the en= coding of a=20 production database? Or the only way is to create a new database with the= =20 correct enconding???
 
  Thanks!

------=_Part_34569_19791327.1146578847177--