IntermediateString Functions

FORMAT: printf-style string formatting

The query

SQL

SELECT
  FORMAT('Employee: %s %s, Salary: $%s', first_name, last_name, salary::TEXT) AS description
FROM employees
LIMIT 5;

Tested against PostgreSQL 16

Note

“FORMAT is PostgreSQL's printf. Useful for generating dynamic SQL strings.