PostgreSQL Function Reference

SUBSTRING

Extracts a substring from a string starting at a given position for a given length.

PostgreSQL 17.5

SUBSTRING(string FROM start FOR length)

string

The source string.

start

The starting position (1-based).

length

The number of characters to extract.

Examples

PostgreSQL 17.5

SELECT SUBSTRING(
		'PostgreSQL'
		FROM 1 FOR 8
	)