LEFT Function - SQL Server to PostgreSQL Migration

In SQL Server and PostgreSQL, the LEFT function returns the specified number of characters from the left part of the string.

SQL Server:

  -- Return 5 left characters
  SELECT LEFT('Hello, world!', 5);
  # Hello

PostgreSQL:

  -- Return 5 left characters
  SELECT LEFT('Hello, world!', 5);
  # Hello

For more information, see SQL Server to PostgreSQL Migration.