susemail(at)hawaii(dot)rr(dot)com (Jerome Lyles) wrote in
news:200409141105(dot)46091(dot)susemail(at)hawaii(dot)rr(dot)com:
> I have a small training database: sql_tutorial. It works fine but the
spacing
> between the output lines is too much. This is the way it looks when I
copy
> and paste from the Konsole to this email:
the simplest is
SELECT prod_name::text FROM products;
(will cast the char(255) column to text and in the process removes all
trailing spaces.)
or use trim function to remove trailing spaces.
--
Rolf