El día Dienstag, März 03, 2020 a las 09:36:32 -0500, Tom Lane escribió: > Matthias Apitz <guru@xxxxxxxxxxx> writes: > > During unload trailing blanks in all columns are discarded, because they > > would cause problems during loading for INT and DATE columns. > > Really? > > regression=# select '123 '::int; > int4 > ------ > 123 > (1 row) > > regression=# select '12-02-2019 '::date; > date > ------------ > 2019-12-02 > (1 row) The problem occurs when loading CSV data like ...| |... into an INT column with COPY. I could make you an exact example. But this wasn't my question, my question is where the document is. matthias -- Matthias Apitz, ✉ guru@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub
