In PostgreSQL, you can't directly enforce a limit on the number of rows a user can retrieve with a SELECT statement at the database permission level. However, you can achieve the desired behavior by using Row-Level Security (RLS) or by creating a security-definer function that restricts access.