Re: Changing the Datatype from Bit to Boolean.

[Holger Jakobs <holger@xxxxxxxxxx>]

Don't hijack threads!

--
Holger Jakobs, Bergisch Gladbach
Tel. +49 178 9759012

Am 23. Februar 2025 15:46:10 MEZ schrieb Mark Smith <mark@xxxxxxxxxxx>:

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

---

From: hellen jiang <hellenjiang99@xxxxxxxxx>
Sent: Sunday, February 23, 2025 8:13:05 AM
To: Gambhir Singh <gambhir.singh05@xxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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.singh05@xxxxxxxxx> 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