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

[Karen Goh <karenworld@xxxxxxxxx>]

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?

I tried using pgAdmin4 but it is not working...:(

On Friday, July 19, 2019, 12:14:04 AM GMT+8, Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:

Hi Karen,

Use below query to change column type text to integer/numeric.

alter table <table_name> alter column <column_name> type int using (column_name::int);
alter table <table_name> alter column <column_name> type numeric using (column_name::numeric);

Hope this will help you.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

On Thu, Jul 18, 2019 at 8:59 PM Karen Goh <karenworld@xxxxxxxxx> wrote:

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.