Select 4e3 AS exponential_float
postgres=# Select 4e3 AS exponential_float; exponential_float ------------------- 4000 (1 row) postgres=#