title: How to find out the connection limit per user on Postgresql?
body: <p>I need to find out if a connection limit has been set on a Postgresql database on a per user basis. </p>
  
  <p>I know you can set such a limit using:</p>
  
  <pre><code>ALTER USER johndoe WITH CONNECTION LIMIT 2;
  </code></pre>
  
  <p>Can you check this in the pg_users table?</p>