[FIXED] How to insert numbers with decimal point in Postgresql database table?

Issue

Numeric datatype doesn't accept decimal points in numbers and PgAdmin 4.2 don't have decimal data type. I want to add percentage numbers like 4.8 and latitude, longitudes something like -89.03177649999999 this. Which is the best data type in postgresql for this king of numbers. PgAdmin only allows numeric datatype to use for numbers. If I add this numbers with numeric data type it throws errors.

Solution

You can absolutely insert values with a decimal point into a numeric column:

create table data (nr decimal);
insert into data 
values 
(-89.03177649999999);

Online example: https://rextester.com/VQB54123

Answered By - a_horse_with_no_name

Answer Checked By - David Marino (PHPFixing Volunteer)