Postgres Pro
Downloads
Home   >   mailing lists

How do I add/edit 'digit' property into PGAdmin4 ? - Mailing list pgsql-admin

From Karen Goh
Subject How do I add/edit 'digit' property into PGAdmin4 ?
Date
Msg-id 503592305.1895694.1563463763702@mail.yahoo.com
Whole thread Raw
Responses Re: How do I add/edit 'digit' property into PGAdmin4 ?  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: How do I add/edit 'digit' property into PGAdmin4 ?  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view 
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
propertyinto PGAdmin4 which is running on windows 10.
 

Thank you.

pgsql-admin by date:

Previous
From: SBob
Date:
Subject: Re: xmin value from pg_stat_replication
Next
From: Shreeyansh Dba
Date:
Subject: Re: How do I add/edit 'digit' property into PGAdmin4 ?