How to migrate column type from uuid to serial

Поиск
Список
Период
Сортировка
От Hemil Ruparel
Тема How to migrate column type from uuid to serial
Дата
Msg-id CANW1aT8fpZqpr6WcN1oj8-0PWjsgorPMEUQguUpO00E=bXYG2A@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to migrate column type from uuid to serial  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: How to migrate column type from uuid to serial  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-general
Дерево обсуждения
I was integrating a payment gateway for my app when I noticed its maximum length of customer id string is 32. SIze of UUID is 36 (32 characters and 4 dashes). So I want to change the type of customer id to serial. The problem is by now, the column is being used at many places. How to migrate the column to serial without dropping the data?

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

Предыдущее
От: Dmitry Igrishin
Дата:
Сообщение: Re: Which is the setup with lowest resources you know Postgres is used in?
Следующее
От: Ron
Дата:
Сообщение: Re: What version specification used by PG community developers?