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 vote184 views3 answers
Convert sql query to python pandas
SQL
0 vote187 views1 answer
Add computed column to table sql server
SQL
2 votes182 views1 answer
Sql missing records from another table
SQL
0 vote181 views1 answer
See Foreign Key
SQL
0 vote187 views1 answer
Sql get date from timestamp
SQL
0 vote200 views1 answer
Delete a temporary table mysql
SQL
10 votes192 views2 answers
What is database
SQL
3 votes200 views1 answer
Async await mysql nodejs
SQL
0 vote182 views1 answer
Mysql identified by syntax error
SQL
2 votes182 views2 answers
Get all columns from table sql
SQL