Re: Perl::DBI and TYPE of column

[Tom Lane]

Matthias Apitz <g...@unixarea.de> 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)

                        regards, tom lane