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:21:16
Message-ID: CANW1aT9WTZ_BMSr_M+kvg-JQN1O2znMUXi88-huqR4fkwU7NVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

umm it is declared as uuid. But how does it occupy only 16 bytes? Even if
we remove those 4 dashes thats 32 bytes of text right? I am not concerned
about the size at all. How do i send it as a string below 32 bytes?

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

> Hemil Ruparel schrieb am 07.10.2020 um 16:02:
> > Yes the id is stored as a uuid.
>
> Then it should be declared with the data type uuid, which only needs 16
> bytes.
>
>
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2020-10-07 14:38:14 Re: How to migrate column type from uuid to serial
Previous Message Thomas Kellerer 2020-10-07 14:06:53 Re: How to migrate column type from uuid to serial