CODEWITHSUNDEEP
sqlpostgresqldecimalsqldatatypes
Gauri
Gauri

Reputation: 329

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

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.

Upvotes: 0

Views: 3578

Answers (1)

user330315
user330315

Reputation:

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

Upvotes: 2

Related Questions