title: Add Unique Constraint to a Postgresql View
body: <p>All,</p>
  
  <p>Is there any way to add a unique constraint to a Postgresql View?</p>
  
  <pre><code>CREATE OR REPLACE VIEW export AS
   (SELECT nextval('export_view'::regclass)::integer AS pid, getdata.id, getdata.service, getdata.title, getdata.date_taken, getdata.date_inserted, getdata.url, 
      regexp_replace(getdata.description, E'[\\n\\r]+', ' ', 'g') AS description, getdata.geom
     FROM getdata)
  </code></pre>
  
  <p>I have tried every combination to get this thing working like a regualr table but it is still not working as needed.</p>
  
  <p>Thanks,
  Adam</p>