Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmtWm-00CLNM-6Q for pgsql-admin@arkaria.postgresql.org; Tue, 25 Feb 2025 11:55:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tmtWl-000koJ-FP for pgsql-admin@arkaria.postgresql.org; Tue, 25 Feb 2025 11:55:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmtWl-000ko8-1X for pgsql-admin@lists.postgresql.org; Tue, 25 Feb 2025 11:55:07 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tmtWh-000f0q-2h for pgsql-admin@lists.postgresql.org; Tue, 25 Feb 2025 11:55:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1740484502; x=1741089302; i=shammat@gmx.net; bh=ZVLFT4sTZBQzshRcOynRpbQCleYikAzP7iQ5ZUJbw18=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=uW2vA8Hp4iJRmOvIKndS7B5UM03PwMXhScIsuhxNoXT75nEtp3HUILfv7JaJxT9J aHg8RNkbtT9cTECUM000BP6cbz0Pxf5QbctiK7pTTut2nV7IxwWe2bhZIIC5xdqFQ an5t4dHs2ZBlt8Ezyi82fu6+BNCEZ+GOZHVGElKF70QTXLwHnVpKOi24hPYGsw7ps 9QTOHL3vXuXwhj1vKrIEnC4pbl71QrFP06G6k+z+I/1vG4LvD876H4uUajRL/vmVx IBU7b7Poc7JvgReRCO3TvNAh+gIcU8EXWWNe/dbMQUDM60dRWV1e0FkrIhormLOG3 MYG/3N2mRPVd80rQGg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.17] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MGQnF-1tW5cJ2KfF-00FAit for ; Tue, 25 Feb 2025 12:55:02 +0100 Message-ID: <88c8494d-92fe-4fbd-bed7-0afd5ef423a1@gmx.net> Date: Tue, 25 Feb 2025 12:55:01 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Changing the Datatype from Bit to Boolean. To: pgsql-admin@lists.postgresql.org References: Content-Language: de-DE From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:/p6ImajvhH38e3fcpcWorBCwREGbsZ4YwKYGHZZ9T7w+J++P3v9 u4lD2gyyWEnfAZBxK8+HMoUmj3s+kHyzrp4uFTyUQkCnlmL3MxRzxv/QFwMuQZ9e7UHOBvv i8yjHM5YYoxfvq0p4UJwe+7nBXoQ2nUQ30ZxgYjCLVGjtuoWcM4h11cw0fDjn0SvHGXExdM fwIze8jFkPgCrMwGKTpzQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:Te1tG8l6nD8=;+5PXt0gNJ/KmtlsTy8jMiyIN2ab /URCAl6OeT3WVmML8scidekNMG1iq4to14h4AszPsgHJhAjpEe/AaEipxPsHTKHhKbfjEYzv2 yqlXJD265QLezEz5QMSQe2xW6URKGjXu89LeAuZbqaJ9B9d6JQGn9SxRtcTQyKDXhORPRRm5R LOTcMy46Qn0afRWYgVD5W3Gmi1GvjVWJ8VC4hMtr7P8HhakZnWjSt2/ojBXJlZqXRU/5cH8El q0gCEAPLcppBjTaEWBmJvmy+iukjewVnobHaW9C3DvxnX0a8Sg0WYu15ROWB7Xd+6VG7JDS7t tCp6v+bSx3DJ+zGlddhNiTU34IbLZvbSZJSlSFniZaqpL6aj2UsPeFsW3fyGY41vE4L4052fW be5xpqtuSb92jH6M7WZVMEVZa/v8Dt6RRymkjMmYy4KZvSRw27MpLBHg7vcWcV3BkYGk8X7cy 9CO1f846dSY2FGRU+GRr2F1QRYjm0PyXX+lBIIFoqFR7WNxfO2ndvvNENGAbIg5BVrsTiFbvK LoYMWPPQX9xy/1G+O1MDFNxBNT1WiiMRzx8ckhLjJy2RgY7uiF8DpgWkUSVBwOG0R71SxgvEU wNgOcNcnCDKqT71fkZG1dQBuUcGS3V911cnmr46KsDTRkODNAqkFjqEN5E0EPMATVpATkotX4 WwtVN31Wi53/3JkgxBbmnT7qIjx81KJQsWXpuVXwe4tN+DVHvPnIr8LIj0nihk/N1vVb1M0Ey Mx6XNZAeu/gEkxYyyiifB1REcke13VncAOIy4WeqOlE0jZhyQa4j2vXdUlXCg3nXsD1Z/aV+P HtiSKT0e/+60IND96ihdbVi3K0DF8Wa3EMVlf1xavQ3QEfPKRE84yXpV1mYf062NxND12R7gg DZegC42aXwy1wcYekC4Vii4C2AfVvysEtnwVBpJ6XhRDdJhePz+EndPvMVodPPw3dOECSP0rQ IZyIGffG97/9N1HwHdWOrVokOlpQthsJnNr1KbxhRbp/C8vRkRIT1txDiNLzfOhlqs/r1lO5B J6BRhNLenXNQKV91nMtMSXe0Dm9Lq11ELnW2EeMYxnlFpR2cu+TK/pb+9MtaEmfxeoojt4dpH AVF3g6k+im7O2idbe1obWHECacC0rAzRFY+der/+l2Yr88WT4y1N5G7eNox6QRPVOoJPCHf8Y KdsaH491V1kzXwB1Y9pS8QlnErfHh5Hl8XY7tagHK4+BHODYw+bicE1zHjnnAaH7EWNnb7vKx oaYh1RCKA2Cz0jGH0uQ6s8R/oc3hX79E6CUX2u1+eaBTXJh4sljvy+90+HhKVvo45OAbb3M2n yy/vCjBx4usode9dEePvh6kazXez5DVh8tLnh8tp5MZeyJ4EU6yWrIPTowKh+Pppn9A6EVTBC q02XMYHFjDHi5Q2CcAa4nERWNP1v46Fq9QYOlk+/oFQTes4AsAJLjVFrJ+ List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Gambhir Singh schrieb am 23.02.2025 um 06:56: > 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. If you store 1 as true and 0 as false, you can use something like this: alter table the_table alter the_column type boolean using (the_column = '1');