Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help---- Urgent

Help---- Urgent

From
Chitta Ranjan Mishra
Date:
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

Re: Help---- Urgent

From
"Andrei Bintintan"
Date:
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

Re: Help---- Urgent

From
"Contact"
Date:
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