I am using PostgreSQL, and I have a column in a table which contains very long text. I want to select this column in a query, but limit its display length.

Something like:

   select longcolumn (only 10 chars) from mytable;

How would I do this?

sql postgresql
Edit
Report