Postgres Pro
Downloads
Home   >   mailing lists

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

From Mark Smith
Subject Re: Changing the Datatype from Bit to Boolean.
Date
Msg-id SA3PR18MB537004622884EDDF4F2C3FB0C8C12@SA3PR18MB5370.namprd18.prod.outlook.com
Whole thread Raw
In response to Re: Changing the Datatype from Bit to Boolean.  (hellen jiang <hellenjiang99@gmail.com>)
Responses Re: Changing the Datatype from Bit to Boolean.
List pgsql-admin
Tree view
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
From: hellen jiang <hellenjiang99@gmail.com>
Sent: Sunday, February 23, 2025 8:13:05 AM
To: Gambhir Singh <gambhir.singh05@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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.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: hellen jiang
Date:
Subject: Re: Changing the Datatype from Bit to Boolean.
Next
From: Holger Jakobs
Date:
Subject: Re: Changing the Datatype from Bit to Boolean.