Subject: Re: Varchar field and numbers
To: pgsql-admin@lists.postgresql.org
References: <c699c25c-d275-5c9c-f040-1108f3878487@slot-it.pl>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <e085f6f8-7023-d60f-bbdf-86f37cbfbcb9@jakobs.com>
Date: Fri, 4 Jun 2021 10:00:22 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.10.2
MIME-Version: 1.0
In-Reply-To: <c699c25c-d275-5c9c-f040-1108f3878487@slot-it.pl>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="NCOAu3NHK4hi7krtGgqPR9gsSIOkmOOF9"
Archived-At: 
 <https://www.postgresql.org/message-id/e085f6f8-7023-d60f-bbdf-86f37cbfbcb9%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--NCOAu3NHK4hi7krtGgqPR9gsSIOkmOOF9
Content-Type: multipart/mixed; boundary="sYgEwOCQ0y4oh5J1eAhjI2Itl24vAnuqk";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <e085f6f8-7023-d60f-bbdf-86f37cbfbcb9@jakobs.com>
Subject: Re: Varchar field and numbers
References: <c699c25c-d275-5c9c-f040-1108f3878487@slot-it.pl>
In-Reply-To: <c699c25c-d275-5c9c-f040-1108f3878487@slot-it.pl>

--sYgEwOCQ0y4oh5J1eAhjI2Itl24vAnuqk
Content-Type: multipart/alternative;
 boundary="------------DE01BF30EA7AACF9CD9FA8DA"
Content-Language: de-DE

This is a multi-part message in MIME format.
--------------DE01BF30EA7AACF9CD9FA8DA
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

This is the wrong list for PgAdmin questions. This one is about=20
PostgreSQL database server.

Am 04.06.21 um 09:39 schrieb Eugeniusz Rink:
>
> Hi.
> PgAdmin 4 v5.3. When I write the result of an SQL query to a file (F8).=

> In a file saved on the disk, a period and zero are added to the=20
> varchar fields where there are numbers.
> Is this a pgAdmin error? This was not the case in the previous version.=

> Is there any quick fix?
>
>
> --=20
> Regards/Pozdrawiam
> Eugeniusz Rink
> -----------------------------------------------------------------------=
-
>
> *TuxMed - Oprogramowanie medyczne*
>
--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


--------------DE01BF30EA7AACF9CD9FA8DA
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p>This is the wrong list for PgAdmin questions. This one is about
      PostgreSQL database server.<br>
    </p>
    <div class=3D"moz-cite-prefix">Am 04.06.21 um 09:39 schrieb Eugeniusz=

      Rink:<br>
    </div>
    <blockquote type=3D"cite"
      cite=3D"mid:c699c25c-d275-5c9c-f040-1108f3878487@slot-it.pl">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <p>Hi.<br>
        PgAdmin 4 v5.3. When I write the result of an SQL query to a
        file (F8).<br>
        In a file saved on the disk, a period and zero are added to the
        varchar fields where there are numbers.<br>
        Is this a pgAdmin error? This was not the case in the previous
        version.<br>
        Is there any quick fix?</p>
      <p><br>
      </p>
      <div class=3D"moz-signature">-- <br>
        Regards/Pozdrawiam<br>
        Eugeniusz Rink<br>
        <hr>
        <p><b>TuxMed - Oprogramowanie medyczne</b></p>
      </div>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------DE01BF30EA7AACF9CD9FA8DA--

--sYgEwOCQ0y4oh5J1eAhjI2Itl24vAnuqk--

--NCOAu3NHK4hi7krtGgqPR9gsSIOkmOOF9
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYLndlgUDAAAAAAAKCRCKV5yTsxlhur44
AKC0bsoZlEfZVkansQnFJIopMbzUAwCcD+xmq5wf/NHYcpRLlVPR6dYaNw8=
=o0+L
-----END PGP SIGNATURE-----

--NCOAu3NHK4hi7krtGgqPR9gsSIOkmOOF9--