Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hoeqP-0002M3-OW for pgsql-admin@arkaria.postgresql.org; Sat, 20 Jul 2019 02:11:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hoeqM-0007TQ-8S for pgsql-admin@arkaria.postgresql.org; Sat, 20 Jul 2019 02:11:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hoeqL-0007TJ-KA for pgsql-admin@lists.postgresql.org; Sat, 20 Jul 2019 02:11:26 +0000 Received: from sonic314-15.consmr.mail.bf2.yahoo.com ([74.6.132.125]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hoeqE-0002mQ-FI for pgsql-admin@lists.postgresql.org; Sat, 20 Jul 2019 02:11:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1563588677; bh=pAwGfkBYxMRCdo/Uzr+ScnQvli7lTv4aKLC5hBQLllA=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject; b=btu6uNU/NR/5wU0sG1dnilOIgbPdHVgdP3M1V4iHHyCbZ29zSXhBCr7NgraHnfmrrUYLVko4foB+bxiVuXtYZhglJkDqs55LbZXksuk1vVngtc1ZTOY2h5MSODf3hAp21ZlSIELFB5KzfIbcjVAuBECzPlxOTQ8Tm4zNpBwqCc+FlH+zVjuOsQUgvlX+mt4WPOggOMePXZPrVAiXFZ+bjzX3s+cflNXr5MgWVoWjkVXCj7YXU70ggXBEnzWxHO6kX/BmD/m3N9XmlPoJaWduqL6iLbfm2RaXh33dXs9GjK3X8NIYVpMlrm+lmgR7H+mvM9VADpAkiH/n/iLyPHjcnw== X-YMail-OSG: bHQmLTkVM1ne0u9aK568q2zTY8v2w5dPDGBzZ.OV8XDr54MZgSrAt3oOr6ep0s2 FYZdY8rhVUTjBLTA8R8pMpWD24h9bq8CU6u7bCH1088YXCcj1Kb2P5IKjN99WPej.7X5h1GeR8vC jW49Su.cDrdBgSlVmkEYk7Yr.Y4rVpPFGHFRoY6HV00qaCH5x_BprmQgILe2pkR0EaOTL0JTRa_b V.RXufTxFHc0O4jhQd0kPrzEmIelJ6AooXWIbQdStIYK.RFREMNYKhAFgKTyJfFFOBo25JDNtwuD m34p.ItSTBr6VfjafphZEEsSZOlHrB.CTRecySzV7AJvGSaKkLkvImR9EHOMT.cjLx85ZJag_dZ8 yp2J8AGpWSrtxI2qx.MHB7MwnNVBx6WxFtUH3TI7AoE9mTLLKmmdIEkdyQEDrqn3SnV.FLBCnUN_ 1f1.YQSUuoj7uE3PVJlvDSNR4BOp0rkz7MKqoEhywZhm7gwew2sqn7kZosT.OGZA1r3zdQujB05L lRhjMoDxuGhzK_nLMuhWGibsWZKqZzAYVQZZ_lP0aEVANU6tfKfDF3x9E8hkl6Qeh.2SJpl9qbQ7 Ps.Y.6q_Sj6HT7AvygzwFTE._p3_jcq1yy_XuwYdHQQLz4DB4ge0zkKNiH13vz0sEf5ILDvN3Sxe X.RW65vSiBV5wxOzIc7HuYJAUlMkBpmxb4MnRfh1q2yu6B_J_0KfQx.t_y5d6Yrw6hGREYeK5tNG n29v5IgRABCzWdIvsmnWzAOb2KH8jnDhVvc1QbX7zo4GGFfFyWtle_VHri49a5j7cCGjw6VFKDoU EwONd1PH95sh2wvSBAoXDHEsfMxqvuaiX4ByUpdgHuaZGWsgjtMOqyE23g9BEEMaT_lq_XADJt6o qQVBZgnpg7PYNwxnFMqOIw4h.JlLDU4wVKnBAt2ovtewjlH68BqU00CfrFu5qP4Yl.Ulzg6sZCYT zIn1JmdQPa0auGKyYAGCsal35vmhaoWzWE74.U_RIk4ITJdskRKFmvogtHHS2Fj8dojZj3ROFU55 aDaAFQgIeBOcvWp4Vot_ciIZfCW.ifm8pXthpZ6UgrtA1OEeiW0y1rTmIsxB_GgNaq_fkIc4woPy SPJN9bBbe1to7fthxMep3.xaqKDnj_ArrM8F0RAn8FRsElZAXm6nBdsYtxPNLJ8uVPdjG7B9HM_z Kn4YDTOCa5xH.3yusAqJPbDQw9UQqvUIcHBndjpT738KYHCvnjcYEOg3u7Qv7yNk0ANZH7esMFt6 zAonTvWw4cvP4zUzyLWGRJd1s9Y7FcoYZQBiN_l238tq6jOJuzpCSxfhxgy8CxHHPIwSKcBH6YA- - Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.bf2.yahoo.com with HTTP; Sat, 20 Jul 2019 02:11:17 +0000 Date: Sat, 20 Jul 2019 02:11:12 +0000 (UTC) From: Karen Goh To: "Anthony E. Greene" , Message-ID: <359037070.2424954.1563588672339@mail.yahoo.com> In-Reply-To: <20190719234044.GA8328@lnxws01.localdomain> References: <503592305.1895694.1563463763702@mail.yahoo.com> <549903142.2203182.1563536801681@mail.yahoo.com> <20190719234044.GA8328@lnxws01.localdomain> Subject: Re: How do I add/edit 'digit' property into PGAdmin4 ? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2424953_327055648.1563588672338" X-Mailer: WebService/1.1.13991 YahooMailIosMobile Yahoo%20Mail/45955 CFNetwork/978.0.7 Darwin/18.6.0 Content-Length: 3916 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2424953_327055648.1563588672338 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Sent from Yahoo Mail for iPhone On Saturday, July 20, 2019, 7:40 AM, Anthony E. Greene wrote: On 19-Jul-2019/11:46 +0000, Karen Goh wrote: > Hi Shreeyansh, > >Due to many mails in my inbox, I got to see your email only now. > >I'd like to seek your help in terms of how to edit the data in this column that I want to change to numeric. > >At one go? > >So, in this column that I used the wrong property type - and now it contains CountryName + the 6 digit numbers. > >Is there any way I can alter the data in that column at one go and remove the CountryName altogether? If the postal code is the last six characters, then this will do what you want: UPDATE mytable SET mycolumn=RIGHT(mycolumn,6) WHERE mycolumn ~ '[0-9]{6}$' Hi Anthony, I tried what you said but very strange I received an error that said my table name is not exists. When I did a data query of all rows, all the data appeared. TG -- Anthony E. Greene ------=_Part_2424953_327055648.1563588672338 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


Sent fr= om Yahoo Mail for iPhone

On S= aturday, July 20, 2019, 7:40 AM, Anthony E. Greene <agreene@pobox.com>= ; wrote:

On 19-Jul-2019/11:46 +0000, Kare= n Goh <karenworld@yahoo.com> wrote:
> Hi Shreeyansh,
>
>= Due to many mails in my inbox, I got to see your email only now.
>
>I'd like to seek your help in terms of= how to edit the data in this column that I want to change to numeric.
>
>At one go?
><= br clear=3D"none">>So, in this column that I used the wrong property typ= e - and now it contains CountryName + the 6 digit numbers.
>
>Is there any way I can alter the data in that = column at one go and remove the CountryName altogether?
<= br clear=3D"none">If the postal code is the last six characters, then this = will do what you

want:


UPDATE mytable SET = mycolumn=3DRIGHT(mycolumn,6) WHERE mycolumn ~ '[0-9]{6}$'

H= i Anthony, I tried what you said but very strange I received an error that = said my table name is not exists. When I did a data query of all rows, all = the data appeared.



TG=
--
Anthony E. Greene <mailto:agreene@pobox.com
>



------=_Part_2424953_327055648.1563588672338--