title: I am not able to create view in PostgreSQL
body: <p>I am trying to create a view in Postgres. I am using Dbeaver to do so.
  my query is as follows:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE VIEW customer_master as
  (
  select * 
  from survey_info 
    full join survey_responses on survey_info.submissionid =survey_responses.submissionid 
  );
  </code></pre>
  
  <p>It's throwing an error :</p>
  
  <blockquote>
    <p>CREATE VIEW customer_master as
    SQL Error [42701]: ERROR: column "submissionid" specified more than once.</p>
  </blockquote>
  
  <p>Anyone faced such an issue?</p>