Re: changing field length

Поиск
Список
Период
Сортировка
От Jodi Kanter
Тема Re: changing field length
Дата
Msg-id 3F4382C6.3030101@virginia.edu
обсуждение исходный текст
Ответ на changing field length  (Jodi Kanter <jkanter@virginia.edu>)
Ответы Re: changing field length  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-admin
how do I copy from one field to another?

Gaetano Mendola wrote:
"Jodi Kanter" <jkanter@virginia.edu> wrote:
I am running 7.3.3. Can I change a field that is varying character(128) 
to varying character(250)?

nope.

You can
a) create a new column named tmp of character(250).
b) copy the content from old column to new column
c) drop the old column
d) rename the tmp column to the correct name


Regards
Gaeatano Mendola

PS: Be carefull with the constraint....



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Somasekhar Bangalore"
Дата:
Сообщение: Need Help on query tuning
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: changing field length