Re: How to migrate column type from uuid to serial

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To:
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to migrate column type from uuid to serial
Date: 2020-10-07 14:38:14
Message-ID: 9ea3ff13-d78b-b5ce-2619-72cb02522e90@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hemil Ruparel schrieb am 07.10.2020 um 16:21:
> it is declared as uuid. But how does it occupy only 16 bytes?

Because a UUID is internally simply a 128bit number - the dashes you see are just formatting.

But if you can only send the text represnation, then yes 32 characters aren't enough.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hemil Ruparel 2020-10-07 14:40:34 Re: How to migrate column type from uuid to serial
Previous Message Hemil Ruparel 2020-10-07 14:21:16 Re: How to migrate column type from uuid to serial