### extra_float_digits

This parameter adjusts the number of digits displayed for floating-point values, including float4, float8, and geometric data types. The parameter value is added to the standard number of digits (`FLT_DIG`

or `DBL_DIG`

as appropriate). The value can be set as high as 3, to include partially-significant digits; this is especially useful for dumping float data that needs to be restored exactly. Or it can be set negative to suppress unwanted digits. See also datatype-float.

#### Recommendations

Only significant for applications which do a lot of float calculations, like scientific databases.

#### Comments

Type: | `integer` |

Default: | `0` |

Min: | `-15` |

Max: | `3` |

Context: | `user` |

Restart: | `false` |

#### On StackOverflow

- SET extra_float_digits = 3 in postgresql
- pycharm and postgres: ERROR: Unsupported startup parameter: extra_float_digits
- PostgreSQL pg_stat_activity gets filled with "SET extra_float_digits = 3" query causing Error calling Driver#connect
- Postgres NetBeans connection driver issue
- How to avoid the idle connections in postgres 9.3