change field type and length

From: "Devi Munandar" <devi(at)informatika(dot)lipi(dot)go(dot)id>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: change field type and length
Date: 2003-04-18 05:13:34
Message-ID: 003301c30569$43003d60$a6f0cda7@informatika.lipi.go.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michiel Lange 2003-04-18 05:23:32 Re: change field type and length
Previous Message Mike Castle 2003-04-17 23:15:01 Re: Require Assistance Solving Problem - erroneous pg_hba.conf