Обсуждение: 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
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
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