'Decimal' and 'Numeric' is not available in PostgreSQL

Question

I want to create a new column in my table with a type decimal and numeric, but it is not available in my Data Type option. Why is it?

I am not sure which tool you are using to create columns bubt decimal and numeric types are supported in postgresql postgresql.org/docs/9.1/static/datatype-numeric.html — Sunil B N
– Sunil B N, Commented Jan 4, 2016 at 6:27
@SunilBN - Yeah, Ive been through that page. Im using Pgadmin 1.14.2 — user4621642
– user4621642, Commented Jan 4, 2016 at 6:43
The types decimal and numeric are equivalent. Both types are part of the SQL standard. Decimal doesn't appear in the list but Numeric does. Please show the data types starting with N. — Elad
– Elad, Commented Jan 4, 2016 at 6:59
@Elad --> Thanks. That's the right answer. You may put your answer to the answer section so that I can mark it right. — user4621642
– user4621642, Commented Jan 4, 2016 at 7:02

Elad · Accepted Answer · 2016-01-04 07:04:52Z

5

The types decimal and numeric are equivalent. Both types are part of the SQL standard. Decimal doesn't appear in the list but Numeric does.

answered Jan 4, 2016 at 7:04

Elad

8945 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1