Postgres Pro
Downloads
Home   >   mailing lists

How to migrate column type from uuid to serial - Mailing list pgsql-general

From Hemil Ruparel
Subject How to migrate column type from uuid to serial
Date
Msg-id CANW1aT8fpZqpr6WcN1oj8-0PWjsgorPMEUQguUpO00E=bXYG2A@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Dmitry Igrishin
Date:
Subject: Re: Which is the setup with lowest resources you know Postgres is used in?
Next
From: Ron
Date:
Subject: Re: What version specification used by PG community developers?