Re: How do I add/edit 'digit' property into PGAdmin4 ?
| От | Shreeyansh Dba |
|---|---|
| Тема | Re: How do I add/edit 'digit' property into PGAdmin4 ? |
| Дата | |
| Msg-id | CAGDYbUOzp1BQQO+Mi+cHKReG1FcOzWnnFFQZ9LjmJBL4f8kDnA@mail.gmail.com обсуждение исходный текст |
| Ответ на | How do I add/edit 'digit' property into PGAdmin4 ? (Karen Goh <karenworld@yahoo.com>) |
| Ответы |
Re: How do I add/edit 'digit' property into PGAdmin4 ?
|
| Список | pgsql-admin |
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.
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.
On Thu, Jul 18, 2019 at 8:59 PM Karen Goh <karenworld@yahoo.com> 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.
В списке pgsql-admin по дате отправления: