Adenilton Batista da Silva escreveu: > (...) > Tenho a seguinte tabela: > > CREATE TABLE clientes > ( > codigo integer NOT NULL, > denominacao character varying(1) NOT NULL, > dtcadastro date NOT NULL, > ultmovimentacao date, > nome character varying(50) NOT NULL, > sexo character varying(1), > dtnascimento date, > apelido character varying(50), > endereco character varying(50), > complemento character varying(50), > bairro character varying(15), > cidade character varying(30), > estado character varying(2), > cep character varying(9), > fone character varying(20), > fax character varying(10), > restricao boolean, > cpfcnpj character varying(14), > rgie character varying(10), > orgemissor character varying(5), > ufemissor character varying(2), > limitecredito numeric(15,2), > pai character varying(50), > mae character varying(50), > conjuge character varying(50), > profissao character varying(30), > email character varying(50), > cbendereco character varying(50), > cbcomplemento character varying(50), > cbbairro character varying(15), > cbcidade character varying(30), > cbestado character varying(2), > cbcep character varying(9), > cbfone character varying(20), > cbfax character varying(10), > obs character varying(100), > ativo boolean NOT NULL, > foto oid, > CONSTRAINT clientes_pkey PRIMARY KEY (codigo) > )
Ola Adenilton, Não querendo me intrometer mas já me intrometendo, uma normalização nessa entidade seria uma boa ein? [ ]s Guedes _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral