Currently format_sql_value outputs inf for infinity, but SQLite doesn't understand that on import. It will understand 9e999 and treat that as infinity, although postgres retains the full precision.

It should be possible to make a dump of a sqlite database containing these values, and be able to restore it with sqlite.