postgresql select substring pattern code example Example: postgresql substring SELECT substring('w3resource' from 4 for 5);