pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: mallah@trade-india.com
To: vernonw@gatewaytech.com
Cc: pgsql-sql@postgresql.org
Subject: Re: How to rename and drop a column in pg7.3?
Date: Fri, 31 Jan 2003 08:28:31 +0530 (IST)
Message-ID: <22043.219.65.233.66.1043981911.squirrel@mail.trade-india.com> (raw)
In-Reply-To: <YW84X1X9542LHJEHFA0FDEYXYWRPA7.3e39ce37@kimiko>
References: <YW84X1X9542LHJEHFA0FDEYXYWRPA7.3e39ce37@kimiko>



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@postgresql.org)



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/





view thread (2+ messages)

Message-ID: <22043.219.65.233.66.1043981911.squirrel@mail.trade-india.com>
Permalink:  ../22043.219.65.233.66.1043981911.squirrel@mail.trade-india.com/
Also on:    postgresql.org/message-id/22043.219.65.233.66.1043981911.squirrel@mail.trade-india.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mallah@trade-india.com, vernonw@gatewaytech.com
  Subject: Re: How to rename and drop a column in pg7.3?
  In-Reply-To: <22043.219.65.233.66.1043981911.squirrel@mail.trade-india.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox