Re: DBD::Pg exorts char columns with trailing blanks - Mailing list pgsql-general

From Matthias Apitz
Subject Re: DBD::Pg exorts char columns with trailing blanks
Date
Msg-id 20191018144226.GA2930@c720-r342378
Whole thread Raw
In response to Re: DBD::Pg exorts char columns with trailing blanks  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: DBD::Pg exorts char columns with trailing blanks
List pgsql-general
El día viernes, octubre 18, 2019 a las 03:01:58p. m. +0200, Tom Lane escribió:

> Matthias Apitz <guru@unixarea.de> writes:
> > When we export char columns with our Perl tools, they come out  with trailing blanks (in Sybase they don't). Can
thisbe suppressed?
 
> 
> Switch to varchar, perhaps?
> 
>             regards, tom lane

Sometimes people does not know, what they propose. We have a historical
25 years grown ILS which runs on top of Sybase, Oracle, Informix ... and
should now be ported to PostgreSQL. We can't simple switch internal
table structures and adopt some 10.000.000 lines of code (or debug while
it is now crashing).

Thanks anyway.

    matthias


-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

3. Oktober! Wir gratulieren! Der Berliner Fernsehturm wird 50 
aus: https://www.jungewelt.de/2019/10-02/index.php



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: connection timeout with psycopg2
Next
From: Adrian Klaver
Date:
Subject: Re: DBD::Pg exorts char columns with trailing blanks