Tuesday, 6 August 2013

How to remove space while inserting and fetching data in and from postgres table?

How to remove space while inserting and fetching data in and from postgres
table?

Whenever i tried to insert or fetch data from the table in postgreSQL it
adds space prefix and suffix of data value. I tried using trim function in
query and also in variable while storing fetch data but it didn't help.
Any way to to get rid of unwanted spaces?
Thanks in advance

No comments:

Post a Comment