Re: PostgreSQL delete the blank in the end of the String - Mailing list pgsql-general

From Stephan Szabo
Subject Re: PostgreSQL delete the blank in the end of the String
Date
Msg-id 20040521072347.Q46005@megazone.bigpanda.com
Whole thread Raw
In response to PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?  (rong.xie@stud.tu-muenchen.de)
List pgsql-general
On Tue, 18 May 2004 rong.xie@stud.tu-muenchen.de wrote:

> hello,
>
> my Name is Rong. I am student at TU-Munich. I have some questions for
> Postgresql7.2  under SuSe Linux.
> Postgresql7.2  under SuSe Linux8.0.
> I use PostgreSQL7.2 with PGAdminII1.4.2 under Windows2000.

Note, 7.2 is fairly old (and I hope you really mean 7.2.x for the last x
in the set of 7.2 versions)

> I insert a String from Teleform6.0 of Cardiff through ODBC in table of
> PostgreSQL.
> There should be some blank in the End of the String. e.g: "data
>      "
> But there ist no blank in the end of the String in the table. e.g: "data"
> It means, that PostgreSQL delete the blank in the end of the String
> automatically.
> But I need the blank in the end of the String.

What type are you inserting into?  Can you give a self contained set of
table creation and inserts to show the problem?

pgsql-general by date:

Previous
From: Adam Ruth
Date:
Subject: Re: ORDER BY 'DK', 'DE', DESC?
Next
From: "Alex Scollay"
Date:
Subject: Automatically fudging query results?