Help---- Urgent

Поиск
Список
Период
Сортировка
Искать

Help---- Urgent

От:
Chitta Ranjan Mishra <c_r_mishra@yahoo.co.in>
Дата:
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

От:
"Andrei Bintintan" <klodoma@ar-sd.net>
Дата:
Create a new column

alter  add column  varchar(25);

Then copy the old column into the new column:
update  set  = ;

Drop the last column:
alter  drop column ;

Rename the column:
alter  rename column  to ;

Take care for INDEXES if there are any.

This should do it.

Best regards. 


----- Original Message ----- 
From: "Chitta Ranjan Mishra" 
To: 
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

От:
"Contact" <contact@ar-sd.net>
Дата:
Create a new column

alter  add column  varchar(25);

Then copy the old column into the new column:
update  set  = ;

Drop the last column:
alter  drop column ;

Rename the column:
alter  rename column  to ;

Take care for INDEXES if there are any.

This should do it.

Best regards. 


----- Original Message ----- 
From: "Chitta Ranjan Mishra" 
To: 
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
FAQ