Re: Can WE modify column of a table in postgres 7.3 - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: Can WE modify column of a table in postgres 7.3
Date
Msg-id 20050402010542.GA8963@winnie.fuhr.org
Whole thread Raw
In response to Can WE modify column of a table in postgres 7.3  ("sharma;G.S." <ghanshyam@newgen.co.in>)
List 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/

pgsql-admin by date:

Previous
From: "Chris White (cjwhite)"
Date:
Subject: Re: Help understanding VACUUM info on 7.4.5
Next
From: Christopher Browne
Date:
Subject: Re: Disk Encryption - Postgresql vs. Oracle