Re: Help---- Urgent - Mailing list pgsql-admin

From Andrei Bintintan
Subject Re: Help---- Urgent
Date
Msg-id 005a01c3bffd$73acc740$0b00a8c0@andyy
Whole thread Raw
In response to Help---- Urgent  (Chitta Ranjan Mishra <c_r_mishra@yahoo.co.in>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Running Postgres Daemons with same data files
Next
From: Tom Lane
Date:
Subject: Re: Shutting down pgsql