PostgreSQL | Using ROWNUM with row_number()

This shows how to use the equivalent of Oracle’s ROWNUM in PostgreSQL.

SELECT (row_number() over()) AS rownum
     , id
     , title
  FROM board