Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing the Datatype from Bit to Boolean. - Mailing list pgsql-admin

From hellen jiang
Subject Re: Changing the Datatype from Bit to Boolean.
Date
Msg-id CABq7sNzVR=q+GjhqxbubTocO5H8cMwEU3OtO_Criyq+ib+0jkw@mail.gmail.com
Whole thread Raw
In response to Changing the Datatype from Bit to Boolean.  (Gambhir Singh <gambhir.singh05@gmail.com>)
Responses Re: Changing the Datatype from Bit to Boolean.
List pgsql-admin
Tree view

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

On Sun, Feb 23, 2025, 12:58 AM Gambhir Singh <gambhir.singh05@gmail.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

pgsql-admin by date:

Previous
From: Gambhir Singh
Date:
Subject: Changing the Datatype from Bit to Boolean.
Next
From: Mark Smith
Date:
Subject: Re: Changing the Datatype from Bit to Boolean.