Postgresql :i want tro truncate column
try this

select autori, substring(titolo,1,20) || '...'
from generale where titolo  ~* 'hp-ux' order by titolo;


it truncates your output but doesn't touch the data in the table