Postgres trim string from end?

Question

PostgreSQL

How to take the last 10 characters from a string?

Answer 1

select substring ( 'yyyyyyyyyyyyy' from length ('yyyyyyyyyyyyy') - 10 )

Answer 2

select 
  substring(fieldname, char_length(fieldname) - 10)
from tablename;

Answer 3

SELECT right(fieldname, 10) FROM tablename;