Converting an existing table?

Поиск
Список
Период
Сортировка
От Zot O'Connor
Тема Converting an existing table?
Дата
Msg-id 37E2ACC7.E2513AD9@zotconsulting.com
обсуждение исходный текст
Ответы Re: [SQL] Converting an existing table?
Список pgsql-sql
I need to change the type on an existing table.  From money to something
else.

What is the best way under postgres?

I could do a query and put it in a new field and then rename the old
field, and then rename the new field.

I then have the old (renamed) field hanging around.  Is there a cleaner
way of doing this?

I also need to change the length of a variable length field.

-- 
Zot O'Connor

www.ZotConsulting.com
www.WhiteKnightHackers.com


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

Предыдущее
От: nathan
Дата:
Сообщение: Select statements on a table that has null fields
Следующее
От: sniper7107@yahoo.com
Дата:
Сообщение: ¸ÞÀϹ߼۱âÀÔ´Ï´Ù ½Ã°£´ç20¸¸°³¸¦ ¹ß¼ÛÇÒ¼öÀÕ½¿´Ï´Ù