Re: Changing the Datatype from Bit to Boolean.

Don't hijack threads!
--
Holger Jakobs, Bergisch Gladbach
Tel. +49 178 9759012

Am 23. Februar 2025 15:46:10 MEZ schrieb Mark Smith <mark(at)zoneget(dot)com>:
>I am new to PostgreSQL. I am trying to restore a db downloaded from GitHub. Pg_restore is coming with error when tried using pgAdmin. Can you tell what the reason could be?
>
>Thanks for your help.
>
>Mark
>
>Get Outlook for iOS<https://aka.ms/o0ukef>
>________________________________
>From: hellen jiang <hellenjiang99(at)gmail(dot)com>
>Sent: Sunday, February 23, 2025 8:13:05 AM
>To: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
>Cc: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
>Subject: Re: Changing the Datatype from Bit to Boolean.
>
>
>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<mailto: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
>