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 1ho8Lg-00013b-Jy for pgsql-admin@arkaria.postgresql.org; Thu, 18 Jul 2019 15:29:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ho8Lf-0004r8-En for pgsql-admin@arkaria.postgresql.org; Thu, 18 Jul 2019 15:29:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ho8Le-0004r1-G4 for pgsql-admin@lists.postgresql.org; Thu, 18 Jul 2019 15:29:35 +0000 Received: from sonic316-11.consmr.mail.bf2.yahoo.com ([74.6.130.121]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ho8Lb-0007eQ-TE for pgsql-admin@lists.postgresql.org; Thu, 18 Jul 2019 15:29:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1563463768; bh=SBfhwMa1lDgztPkuIbJgIDB7qZCzzZz8bmmMgMSTpiA=; h=Date:From:To:Subject:From:Subject; b=eSGRBQL1a0vszTK3PiO2zo5dNJVUd2m+LneUdOPe68oF3DtbKr7dFxMf0LoVmQzn2F+nIrGA5Dlp8K+b4X0LyNMzPTRaeRR2iTpdgcUaTYKu448N0ach+4B3aoAafsdjkAh2NGpUTFhAcwOv87xNNfDEnOWm9TYY4WVbw59yILD2YW4QGcLex+32LTSA6Lkb84N+QQ1pJnDUHOTHk4oyLt5y3+tsJ/WGl3kJJdS0FOS8TfHRUKIXjgfQgLORAICqeViCZpTDb8SMVHNlTn4xYElz8Io2/vk1qOdPOVZxlVkZKLeINkR2At5zqhDNq/EfIuDvKKhTFQWg50b1c3XnVw== X-YMail-OSG: R.WbABcVM1nSzEMshR9feC75JGUAchudMik6TBFaHXHZQViNfPMvvzyiLt6hZ_D TOUkZTh8kkPGmrsVduIKTG8vCzzhYm_Zh1gys3IUdz9ET_LdlGKgSVPn_Vu9zqshdbCshpKffksO 6mC75.S.c9S2cSm06UXP6UNUTk_b527.YPVpNu5jpyzRhKj1_EVtby6mh41eatAsNQT24NMvS.FW 0SLRwQYymWI7f9VcU0t11hiXg5T35SYowFZXMJ_8kKGAod7yv7gycAcSdd.4I2bqMjhEMp84BxkJ NYTStbPezYZxbxJH_aIp6tQmzatml1wW_Wu9JTIQYHzzBSNVEJCl1uRjld7LWDFuh.iCYrZETduZ 8Uqyibl1ucfQe4jfAI8TpzjVDKmPYdKi3cfmrXrXrv1u5HIAGVy9vbVC6NmrsLMknP6uuPiHs_SR 9gGPu7rcigXHy6C9bKKhOc.YSsYFZmdepIcpDysp.h3aPiBN617ByYUG1tZ5H3joiv8TAiAMOCAw WcNUooOu7Oxsvbkn5.RVwPavnYZDNau8ktgadYHjO3VqfTxf5PXNM5oSce36bg2HJvvLyo27Dq60 KuRMx2uBxLCM5P6LqIrDKB9D676kEFWZU2rRVVGe07W1ex6aRuR_Q_13rhQGhvhB8p5FC53m0lfj 4SC8gCMvTLPbRe8qcrLYa1zD0G_f2pxHKbHC3AynF7BhREfcXfosvcjowZmpg8NF6O8haRwTcRlB 9vFn5C9f.uuW3VQM9Cp5u8GvkUBNjh.8t6bXEvhXAkn_lvlGncW1PgN78VCghkBwJz7ZR36wnnSz UFZMbRe8BcS55jcIoY6N3r7QZe2kofn.LPCgN4O.acjVC5o.qQ3YKw6LhOqHK4APmhbxsieP1jfB aC1nl4Pj984C9fyIRG2WjflqxdBgC8t_CMFg2fTFaTKzTSUcsKm9kJcICDxOviG45nKPgIV2zXvF aqDDbkm7vTW_AGlEJL4dLAxUOp.bzB4o.OT25Wlejozp0YRhuiwOwCZ9oJduYnwM3_Be77osjWdO OsdV3Fdm0X9eqVcGsoj3Cilxeih2Su_eIdj_bijJEg1dnYFgdjYp1qN0_FHcFJLiv_hCnDFkedGH Z3BsD3VOQlXUVtXQzt.wtmaa.Rnia9c3k78KKKX5wAiY1iukrdvRID_xinZ4ybkaLqfAkqAao5OV 90fRNsM3C2SN8ARH4vku8YoD1Wh7XFPbx9ZAoPd2GSEldUZLrZeqj7AzYjizg Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Thu, 18 Jul 2019 15:29:28 +0000 Date: Thu, 18 Jul 2019 15:29:23 +0000 (UTC) From: Karen Goh To: pgsql-admin@lists.postgresql.org Message-ID: <503592305.1895694.1563463763702@mail.yahoo.com> Subject: How do I add/edit 'digit' property into PGAdmin4 ? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 451 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, I need help to change an existing column in my table from text to 'digit' type. However, I can't find any numeric or integer property type. The digit type should contains numbers only but it is not for calculation. It is a zipcode that has 6 digit numbers. Please let me know how do I alter the text type to digit type. If alteration is not possible, how do I add in the property into PGAdmin4 which is running on windows 10. Thank you.