Search Postgresql Archives

Re: DBD::Pg exorts char columns with trailing blanks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: DBD::Pg exorts char columns with trailing blanks
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Fri, 18 Oct 2019 15:01:58 +0200
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
Comments: In-reply-to Matthias Apitz <guru@xxxxxxxxxxx> message dated "Fri, 18 Oct 2019 12:19:37 -0000"
In-reply-to: <80o3yg.pzkkx1.2uoaif-qmf@ms-10.1blu.de>
References: <80o3yg.pzkkx1.2uoaif-qmf@ms-10.1blu.de>

Matthias Apitz <guru@xxxxxxxxxxx> writes:
> When we export char columns with our Perl tools, they come out  with trailing blanks (in Sybase they don't). Can this be suppressed?

Switch to varchar, perhaps?

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: DBD::Pg exorts char columns with trailing blanks
  - From: Matthias Apitz

References:
- DBD::Pg exorts char columns with trailing blanks
  - From: Matthias Apitz

Prev by Date: Visibility Map Issues
Next by Date: RE: CVE-2018-1058
Previous by thread: DBD::Pg exorts char columns with trailing blanks
Next by thread: Re: DBD::Pg exorts char columns with trailing blanks
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux