This is another discuttion about this problem.
Please read these mails.
I cannot write here all the syntax:
I'll give an example: you have a table called "person" and you have a column
called "name" varchar(10) and you want to change it into varchar(25).
alter person add column name_temp varchar(25);
update person set name_temp = name;
alter person drop column name;
alter person rename column name_temp to name;
This is it. Now depending on you database complexity if you have a complex
database and a lot of indexes or triggers, you will have to drop these items
and rebuild them.
Have fun.
Andy.
----- Original Message -----
From: "Chitta Ranjan Mishra" <***@yahoo.co.in>
To: "Andrei Bintintan" <***@ar-sd.net>
Sent: Friday, December 12, 2003 5:46 AM
Subject: [ADMIN] Help---- Urgent
Dear Sir,
Thanks for your reply. Kindly send me the syntax
for all this.
Thanking you,
Regds
C.R.Mishra
Create a new column
alter <tablename> add column <newcolname>
varchar(25);
update <tablename> set <newcolname> = <oldcolname>;
alter <tablename> drop column <oldcolname>;
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"
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...
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
________________________________________________________________________
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com
----- Original Message -----
From: Jodi Kanter
To: Postgres Admin List
Sent: Tuesday, December 16, 2003 7:32 PM
Subject: [ADMIN] character type modification
Can I alter a column from character varying(128) to text without having to create a temp table? I am running 7.3.3.
Thanks
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
***@virginia.edu
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
<!--[if !supportEmptyParas]--> <!--[endif]-->
<!--[if !supportEmptyParas]--> <!--[endif]-->
<!--[if !supportEmptyParas]--> <!--[endif]-->