How do I add/edit 'digit' property into PGAdmin4 ?

From: Karen Goh <karenworld(at)yahoo(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: How do I add/edit 'digit' property into PGAdmin4 ?
Date: 2019-07-18 15:29:23
Message-ID: 503592305.1895694.1563463763702@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2019-07-18 16:12:18 Re: How do I add/edit 'digit' property into PGAdmin4 ?
Previous Message SBob 2019-07-17 23:03:16 Re: xmin value from pg_stat_replication