substring postgresql code example

Example 1: postgresql substring

SELECT substring('w3resource' from 4 for 5);

Example 2: postgresql certain first 4 characters in string

SELECT employee_id,first_name,
substring(first_name,1,4)
FROM employees;