title: Postgres - limit number of rows COPY FROM
body: <p>Is there a way to limit the Postgres <code>COPY FROM</code> syntax to only the first row? There doesn't seem to be an option listed in the documentation.</p>
  
  <p>I know there's that functionality in SQL Server, see <code>FIRSTROW</code> AND <code>LASTROW</code> options below:</p>
  
  <pre><code>BULK INSERT sometable
  FROM 'E:\filefromabove.txt
  WITH
  (
  FIRSTROW = 2,
  LASTROW = 4,
  FIELDTERMINATOR= '|',
  ROWTERMINATOR = '\n'
  )
  </code></pre>