Lists: | pgsql-admin |
---|
From: | "sharma;G(dot)S(dot)" <ghanshyam(at)newgen(dot)co(dot)in> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Can WE modify column of a table in postgres 7.3 |
Date: | 2005-04-01 07:07:51 |
Message-ID: | 00a301c53689$86d2ab60$be05a8c0@ng3024 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
I want to
rename and modify the data type of a column in postgres 7.3 can any body help me ...that it is possible to do the above in postgres and if yes pls provide me the syntax
thanx in advance
From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | "sharma;G(dot)S(dot)" <ghanshyam(at)newgen(dot)co(dot)in> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Can WE modify column of a table in postgres 7.3 |
Date: | 2005-04-02 01:05:42 |
Message-ID: | 20050402010542.GA8963@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
On Fri, Apr 01, 2005 at 12:37:51PM +0530, sharma;G.S. wrote:
>
> I want to rename and modify the data type of a column in postgres 7.3
> can any body help me ...that it is possible to do the above in postgres
> and if yes pls provide me the syntax
You can rename columns with ALTER TABLE:
http://www.postgresql.org/docs/7.3/interactive/sql-altertable.html
In 8.0 and later you can use ALTER TABLE to change a column's type;
see the FAQ for how to do it in older versions:
http://www.postgresql.org/docs/faqs.FAQ.html#4.3
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/