sql - How to limit the maximum display length of a column in PostgreSQL -

i using postgresql, , have column in table contains long text. want select column in query, limit display length.

something like:

   select longcolumn (only 10 chars) mytable; 

how this?

what can use postgresql's substring() method. either 1 of 2 commands below work:

select substring(longcolumn 10) mytable; select substring(longcolumn 1 10) mytable;