Lists: | pgsql-sql |
---|
From: | Vernon Wu <vernonw(at)gatewaytech(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | How to rename and drop a column in pg7.3? |
Date: | 2003-01-31 01:15:35 |
Message-ID: | YW84X1X9542LHJEHFA0FDEYXYWRPA7.3e39ce37@kimiko |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
I need to rename and remove columns of a table. Is any new way to accomplish the two tasks in 7.3? I have searched
the online document and don't see any related information.
Thanks,
Vernon
From: | <mallah(at)trade-india(dot)com> |
---|---|
To: | <vernonw(at)gatewaytech(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: How to rename and drop a column in pg7.3? |
Date: | 2003-01-31 02:58:31 |
Message-ID: | 22043.219.65.233.66.1043981911.squirrel@mail.trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
Hmmm... both are supported in 7.3.x
ALTER TABLE rtfm RENAME f1 to f2 ;
ALTER TABLE rtfm DROP COLUMN f3;
hope it helps.
regds
mallah.
>
> I need to rename and remove columns of a table. Is any new way to accomplish the two tasks in
> 7.3? I have searched the online document and don't see any related information.
>
> Thanks,
>
> Vernon
>
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off
> all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/