change field type and length - Mailing list pgsql-admin

From Devi Munandar
Subject change field type and length
Date
Msg-id 003301c30569$43003d60$a6f0cda7@informatika.lipi.go.id
Whole thread Raw
Responses Re: change field type and length  (Michiel Lange <michiel@minas.demon.nl>)
Re: change field type and length  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
I've created table with postgresql, and so far so good, but I want to change
Field type and field length, I've tried to find command line and
documentation postgresql to change table field, but I can't get it. so there
are any trip to change that field...?

CREATE TABLE "dat_jab" (
   "code_jab" numeric(2,0) NOT NULL,
   "nm_jab" varchar(25),
   CONSTRAINT "dat_jab_pkey" PRIMARY KEY ("code_jab")
);
CREATE  INDEX "dat_jab_code_jab_key" ON "dat_jab" ("code_jab");

***  want to change Field Type "code_jab" numeric(4.0) , and field name
"nm_jab" -->"nm_cdjab"


regards

--dv


pgsql-admin by date:

Previous
From: dalgoda@ix.netcom.com (Mike Castle)
Date:
Subject: Re: Require Assistance Solving Problem - erroneous pg_hba.conf
Next
From: Michiel Lange
Date:
Subject: Re: change field type and length