Erro no backup do banco, geração de caracteres portugues, ambiente windows
xp, postgresql enconding utf-8.
Não está gerando corretamente os caracteres em portugues (acentuação,
cedilha - exemplo: õ, ç)
1. Geração da tabela:
CREATE TABLE area (
id_area serial NOT NULL,
codigo smallint NOT NULL,
nome character varying(40)
);
ALTER TABLE ONLY area
ADD CONSTRAINT pk_area PRIMARY KEY (id_area);
INSERT INTO area (id_area, codigo, nome) VALUES (1, 1, 'Almoço');
INSERT INTO area (id_area, codigo, nome) VALUES (2, 2, 'Refeição');
INSERT INTO area (id_area, codigo, nome) VALUES (3, 3, 'Cardápio');
2: O Backup do banco apresenta erros no comando insert - perda dos
caracteres em portugues:
CREATE TABLE area (
id_area serial NOT NULL,
codigo smallint NOT NULL,
nome character varying(40)
);
ALTER TABLE ONLY area
ADD CONSTRAINT pk_area PRIMARY KEY (id_area);
INSERT INTO area (id_area, codigo, nome) VALUES (1, 1, 'Almoço');
INSERT INTO area (id_area, codigo, nome) VALUES (2, 2, 'Refeição');
INSERT INTO area (id_area, codigo, nome) VALUES (3, 3, 'Cardápio');
2: The Backup of the bank presents mistakes in the command insert - loss of
the characters in Portuguese:
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.0.4
-- Dumped by pg_dump version 9.0.4
-- Started on 2011-07-30 22:55:45
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
--
-- TOC entry 1785 (class 1262 OID 16432)
-- Name: teste01; Type: DATABASE; Schema: -; Owner: postgres
--
CREATE DATABASE teste01 WITH TEMPLATE = template0 ENCODING = 'UTF8'
LC_COLLATE = 'Portuguese, Brazil' LC_CTYPE = 'Portuguese, Brazil';
ALTER DATABASE teste01 OWNER TO postgres;
\connect teste01
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
--
-- TOC entry 308 (class 2612 OID 11574)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--
CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 1501 (class 1259 OID 16435)
-- Dependencies: 5
-- Name: area; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE area (
id_area integer NOT NULL,
codigo smallint NOT NULL,
nome character varying(40)
);
ALTER TABLE public.area OWNER TO postgres;
--
-- TOC entry 1500 (class 1259 OID 16433)
-- Dependencies: 1501 5
-- Name: area_id_area_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE area_id_area_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.area_id_area_seq OWNER TO postgres;
--
-- TOC entry 1788 (class 0 OID 0)
-- Dependencies: 1500
-- Name: area_id_area_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
postgres
--
ALTER SEQUENCE area_id_area_seq OWNED BY area.id_area;
--
-- TOC entry 1789 (class 0 OID 0)
-- Dependencies: 1500
-- Name: area_id_area_seq; Type: SEQUENCE SET; Schema: public; Owner:
postgres
--
SELECT pg_catalog.setval('area_id_area_seq', 1, false);
--
-- TOC entry 1779 (class 2604 OID 16438)
-- Dependencies: 1500 1501 1501
-- Name: id_area; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE area ALTER COLUMN id_area SET DEFAULT
nextval('area_id_area_seq'::regclass);
--
-- TOC entry 1782 (class 0 OID 16435)
-- Dependencies: 1501
-- Data for Name: area; Type: TABLE DATA; Schema: public; Owner: postgres
--
INSERT INTO area VALUES (1, 1, 'Almoço');
INSERT INTO area VALUES (2, 2, 'Refeição');
INSERT INTO area VALUES (3, 3, 'Cardápio');
--
-- TOC entry 1781 (class 2606 OID 16440)
-- Dependencies: 1501 1501
-- Name: pk_area; Type: CONSTRAINT; Schema: public; Owner: postgres;
Tablespace:
--
ALTER TABLE ONLY area
ADD CONSTRAINT pk_area PRIMARY KEY (id_area);
--
-- TOC entry 1787 (class 0 OID 0)
-- Dependencies: 5
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
-- Completed on 2011-07-30 22:55:45
--
-- PostgreSQL database dump complete
--
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
