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

1 vote277 views2 answers
Sql unique rows
SQL
18 votes130 views6 answers
Mysql create table
SQL
0 vote133 views1 answer
Ksql quickstart docker
SQL
-1 vote164 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote127 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote184 views1 answer
Get last inserted primary key
SQL
0 vote132 views1 answer
Sql datediff month
SQL
3 votes121 views1 answer
APEX elapsed time
SQL
6 votes137 views1 answer
T-sql test if table exists
SQL
1 vote119 views1 answer
How to ckeck that email is present in databse in mysqli
SQL