Re: Comando "describe"

2008/1/28 felipe fernandez <ffdez(at)auna(dot)com>:
> Buscando en cakephp he encontrado la query que resuelve mis problemas
>
> SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS
> null, column_default AS default, ordinal_position AS position,
> character_maximum_length AS char_length, character_octet_length AS
> oct_length FROM information_schema.columns WHERE table_name ='tabla'
> ORDER BY position"
>

pongamoslo a prueba ejecuta lo siguiente:

CREATE TABLE public.cuenta_contable
(
empresa smallint NOT NULL,
codigo text NOT NULL,
descripcion text NOT NULL,
nivel1 smallint NOT NULL,
tipo_cuenta character(1) NOT NULL,
tipo_estado_financiero character(1) NOT NULL,
CONSTRAINT cuenta_contable_pkey PRIMARY KEY (codigo, empresa)
);

CREATE SCHEMA contabilidad;

CREATE TABLE contabilidad.cuenta_contable
(
empresa smallint NOT NULL,
codigo text NOT NULL,
descripcion text NOT NULL,
nivel smallint NOT NULL,
tipo_cuenta character(1) NOT NULL,
tipo_estado_financiero character(1) NOT NULL,
CONSTRAINT cuenta_contable_pkey PRIMARY KEY (codigo, empresa)
);

Ahora ejecuta tu query y mira lo que ocurre... (mejor usa el que te da psql -E)

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook