Postgresql datetimes are not ISO-8601 compliant, but RFC3339

Postgresql calls its datetime format ISO-8601 in the documentation and in
the DateStyle setting, but it is in fact not ISO compliant, but RFC3339
instead. To quote the latter (which is freely available unlike the ISO
standard):

NOTE: ISO 8601 defines date and time separated by "T".
Applications using this syntax may choose, for the sake of
readability, to specify a full-date and full-time separated by
(say) a space character.

Basically instead of outputting «2022-02-12 02:53:59.55718+01», it should
output «2022-02-12T02:53:59.55718+01» to be compliant. Fortunately it will
accept compliant datetimes as input just fine. I ran into this because I
was feeding these values into a strict ISO-8601 implementation and it
rejected these values.

The solution that I would suggest for the next major release is to add a
new RFC DateStyle with the current behavior and make the ISO setting do the
conformant thing; and on existing release series add RFC as an alias of ISO
to facilitate the transition for people who may rely on the current
behavior.

Regards,

Leon