Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group