Re: How to migrate column type from uuid to serial

From: Hemil Ruparel <hemilruparel2002(at)gmail(dot)com>
To: Thomas Kellerer <shammat(at)gmx(dot)net>
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:40:34
Message-ID: CANW1aT_DQq5-cBL+1MCbd=hncUwJ3QWk-NWoVpwFxj=RR20hUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry if this is silly but if it is a 128 bit number, why do we need 32
characters to represent it? Isn't 8 bits one byte?

On Wed, Oct 7, 2020 at 8:08 PM Thomas Kellerer <shammat(at)gmx(dot)net> wrote:

> 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 Stephen Frost 2020-10-07 14:41:01 Re: Handling time series data with PostgreSQL
Previous Message Thomas Kellerer 2020-10-07 14:38:14 Re: How to migrate column type from uuid to serial