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 vote153 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote335 views3 answers
Insert or ignore postgres
SQL
3 votes207 views1 answer
Sql server version query
SQL
2 votes209 views3 answers
Copy data from one table column to another table column in sql
SQL
2 votes263 views2 answers
Mysql search for column name in all tables
SQL
6 votes282 views1 answer
How to count number of rows in sql
SQL
4 votes189 views1 answer
Delete record mysql query
SQL
1 vote187 views1 answer
Foreign key constraint in ms sql
SQL
0 vote215 views1 answer
Timestamp(0) postgresql
SQL
0 vote209 views1 answer
Drop column from table if exist on live server mysql
SQL