Re: Help---- Urgent

Create a new column

alter <tablename> add column <newcolname> varchar(25);

Then copy the old column into the new column:
update <tablename> set <newcolname> = <oldcolname>;

Drop the last column:
alter <tablename> drop column <oldcolname>;

Rename the column:
alter <tablename> rename column <newcolname> to <oldcolname>;

Take care for INDEXES if there are any.

This should do it.

Best regards.


----- Original Message -----
From: "Chitta Ranjan Mishra" <c_r_mishra@yahoo.co.in>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, December 11, 2003 7:19 AM
Subject: [ADMIN] Help---- Urgent


> Dear Sir,
>     I wnat to alter the size of one of the column of a
> table. How to do this in Postgres ? Plz help me.
> It's very urgent...
>
> I tried with the following syntax :
> but it failed....
>
> alter table tablename modify(coumnname varchar(25));
>
> it's very urgnet...plz reply soon..
>
> Thanking you,
> Regds
> C.R.Mishra
>
>
>
>
> ________________________________________________________________________
> Yahoo! India Mobile: Download the latest polyphonic ringtones.
> Go to http://in.mobile.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org