Re: Changing the Datatype from Bit to Boolean.

From: hellen jiang <hellenjiang99(at)gmail(dot)com>
To: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Changing the Datatype from Bit to Boolean.
Date: 2025-02-23 14:13:05
Message-ID: CABq7sNzVR=q+GjhqxbubTocO5H8cMwEU3OtO_Criyq+ib+0jkw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

you can add one new column(boolean) and then remove the BIT column。

On Sun, Feb 23, 2025, 12:58 AM Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
wrote:

>
> Hi,
>
> Aurora PostgreSQL DB has a table in which one column has the datatype
> BIT(1). Now the requirement is that I have to change the datatype of that
> column from BIT to BOOLEAN. There are only a few rows in the table.
>
> --
> Thanks & Regards
> Gambhir Singh
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Smith 2025-02-23 14:46:10 Re: Changing the Datatype from Bit to Boolean.
Previous Message Gambhir Singh 2025-02-23 05:56:10 Changing the Datatype from Bit to Boolean.