Float postgres

CREATE TABLE float_point (floatn FLOAT4); 	      -- precision min 4, maximum 8
INSERT INTO float_point (floatn) VALUES (543.23); -- 543,23
CREATE TABLE float_point_r (real_no REAL); 		  -- 1E-37 to 1E+37, 6 decimal max
INSERT INTO float_point_r (real_no) VALUES (12345623); -- 1,234562€+07

Source: educba.com

Postgresql float data type

ALTER TABLE tableName 
ADD COLUMN columnName float(4);

Similar codes

0 vote301 views3 answers
How to find all role in mysql
SQL
0 vote247 views1 answer
Postgresql find missing id
SQL
0 vote258 views1 answer
Dump multiple tables mysql
SQL
1 vote247 views1 answer
Postgres cast as currency format
SQL
0 vote213 views1 answer
Oracle sysdba connect as another user
SQL
1 vote264 views1 answer
Mysql show queries running
SQL
1 vote276 views1 answer
Mysql count all table rows
SQL
0 vote242 views1 answer
Mysql group by derived column
SQL
2 votes280 views1 answer
Pdo mysql insert
SQL
0 vote273 views1 answer
How to locate pg_hba.conf file
SQL