what is a postgres connection limit code example

Example: postgresql limit

SELECT select_list
    FROM table_expression
    LIMIT number OFFSET number