<div>
Hi VK, just to confirm, are you asking how to remove trailing spaces on strings/characters without using the TRIM() function?<br />
<br />
Or are you just trying to trim all strings automatically each query?
</div>


Hi VK, just to confirm, are you asking how to remove trailing spaces on strings/characters without using the TRIM() function?

Or are you just trying to trim all strings automatically each query?

<div>
Hi, &nbsp;<br />
<br />
Yes, &nbsp;I don't want to use any trim function or any additional code, even though you have trailing spaces in the strings, these trailing spaces should trim automatically when saving in the database. &nbsp;I mean, if query database without spaces i should get my results back even my my input data has spaces(trailing). &nbsp; <br />
<br />
In Netezza Postgres you have this feature, you &nbsp;can check online. &nbsp;It is really strange no one &nbsp;tried to respond after so long time.<br />
<br />
Thanks for asking.
</div>


Hi,  

Yes,  I don't want to use any trim function or any additional code, even though you have trailing spaces in the strings, these trailing spaces should trim automatically when saving in the database.  I mean, if query database without spaces i should get my results back even my my input data has spaces(trailing).  

In Netezza Postgres you have this feature, you  can check online.  It is really strange no one  tried to respond after so long time.

Thanks for asking.

<div>
<div class="content wysiwyg-content">
How to set &nbsp;default &nbsp;trim for trailing spaces on strings/characters data in <b>PostgresSQL</b><br />
<br />
if you have string <b>'abc &nbsp; ' &nbsp;</b> &nbsp; it should <b>'abc'</b>. &nbsp; don't want to apply any trim functions manually on each query, Please advise.
</div>
</div>


How to set  default  trim for trailing spaces on strings/characters data in PostgresSQL

if you have string 'abc   '     it should 'abc'.   don't want to apply any trim functions manually on each query, Please advise.

how to set default trim  for trailing spaces on strings/characters  in POSTGRESSQL

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.