I written this query,for fetching data from PostgreSQL to show in my HTML Page without space in text box , SELECT * from table name where column name='"+variable name.trim()+"';
but trim() function in query doesn't worked.
Does PostgreSQL supports trim() function ?if no what is other way to remove spaces?