X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C8FB3533CB for ; Mon, 18 Apr 2005 14:25:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99846-08 for ; Mon, 18 Apr 2005 17:25:44 +0000 (GMT) Received: from planae.com.br (nat.planae.com.br [200.210.129.190]) by svr1.postgresql.org (Postfix) with SMTP id 94C4A535AD for ; Mon, 18 Apr 2005 14:25:41 -0300 (ADT) Received: (qmail 29415 invoked by uid 1004); 18 Apr 2005 17:24:27 -0000 Received: from 192.168.0.215 by mercurio.planae.com.br (envelope-from , uid 0) with qmail-scanner-1.23 (uvscan: v4.3.20/v4471. Clear:RC:1(192.168.0.215):. Processed in 0.883645 secs); 18 Apr 2005 17:24:27 -0000 X-Qmail-Scanner-Mail-From: gfnobrega@planae.com.br via mercurio.planae.com.br X-Qmail-Scanner: 1.23 (Clear:RC:1(192.168.0.215):. Processed in 0.883645 secs) Received: from unknown (HELO gfnobrega) (gfnobrega@192.168.0.215) by 192.168.0.3 with SMTP; 18 Apr 2005 17:24:26 -0000 From: =?iso-8859-1?Q?Gustavo_Franklin_N=F3brega_-_Planae?= To: "'Dextra - Gustavo Bartz Guedes'" , Subject: RES: pg_enconding Date: Mon, 18 Apr 2005 14:24:40 -0300 Organization: =?iso-8859-1?Q?Planae_Tecnologia_da_Informa=E7=E3o?= MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 Thread-Index: AcVENn09fiPvznUCToWSwvSi21tpdwABEA2Q In-Reply-To: <4263E19D.4050008@dextra.com.br> X-Qmail-Scanner-Message-ID: <111384506667729401@mercurio.planae.com.br> Message-Id: <20050418172541.94C4A535AD@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.899 tagged_above=0 required=5 tests=AWL, MSGID_FROM_MTA_ID, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/232 X-Sequence-Number: 17245 Hi Gustavo, pg_encoding has been removed, because is not need anymore. Try this query to see what encoding a database have. SELECT pg_database.datname as "Database", pg_user.usename as "Owner", pg_encoding_to_char(pg_database.encoding) as "Encoding"FROM pg_database, pg_user WHERE pg_database.datdba =3D pg_user.usesysid UNION SELECT pg_database.datname as "Database", NULL as "Owner", pg_encoding_to_char(pg_database.encoding) as "Encoding"FROM pg_database WHERE pg_database.datdba NOT IN (SELECT usesysid FROM pg_user) ORDER BY "Database"; This query was copied from http://archives.postgresql.org/pgsql-php/2001-10/msg00071.php. Thanks to Alessandro Ferrarin. Gustavo Franklin N=F3brega gfnobrega@planae.com.br Infraestrutura e Banco de Dados Planae Tecnologia da Informa=E7=E3o (+55) 14 2106-3514 http://www.planae.com.br -----Mensagem original----- De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Em nome de Dextra - Gustavo = Bartz Guedes Enviada em: segunda-feira, 18 de abril de 2005 13:35 Para: pgsql-admin@postgresql.org Assunto: [ADMIN] pg_enconding The version 8.0 has not the pg_encoding tool, so how can I find a=20 encoding by its number on pg_database.enconding? Thanks. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq