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

Question

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.

The numeric data type certainly accepts decimal points. Please edit the question and provide an SQL statement and error message to demonstrate your problem. — Laurenz Albe
– Laurenz Albe, Commented Mar 14, 2019 at 13:23

user330315 · Accepted Answer · 2019-03-14 13:23:56Z

2

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 Mar 14, 2019 at 13:23

user330315

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

3 Comments

Gauri Over a year ago

greate. I tried creating table with decimal, its accepting the values. When I used gui for create table, there is no decimal data type option available in data types list for columns.

user330315 Over a year ago

@Gauri: numeric is an alias for decimal - does that "GUI" offer numeric?

Gauri Over a year ago

Yes. GUI offers numeric.

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related