Search code examples
postgresqldecimalnumericpgadmin

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


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?

enter image description here


Solution

  • 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.

    enter image description here