title: PostgreSQL Cannot see Data in View rows
body: <p>I am learning how to use PostgreSQL and I have inserted data in my table but I cannot see the data when I click view rows. I get the error message below(2).</p>
  
  <p>(1)Here is the create Table Statement</p>
  
  <pre><code>-- Table: "Test2 Schema"."Jobsearch"
  
  -- DROP TABLE "Test2 Schema"."Jobsearch";
  
  CREATE TABLE "Test2 Schema"."Jobsearch"
  (
      "JobTitle" character varying(30) COLLATE pg_catalog."default",
      "Location" character varying(40) COLLATE pg_catalog."default",
      "Salary" integer,
      "Description" character varying(4000) COLLATE pg_catalog."default",
      "Currency" character varying(6) COLLATE pg_catalog."default",
      "Duration" character varying COLLATE pg_catalog."default",
      "Ref" integer NOT NULL,
      CONSTRAINT "Jobsearch_pkey" PRIMARY KEY ("Ref")
  )
  WITH (
      OIDS = FALSE
  )
  TABLESPACE pg_default;
  
  ALTER TABLE "Test2 Schema"."Jobsearch"
      OWNER to adelton;
  </code></pre>
  
  <p>(2)Here is the error message I get when try to view all rows</p>
  
  <blockquote>
    <p>ERROR: column "ref" does not exist LINE 2: ORDER BY Ref ASC ^ HINT:
    Perhaps you meant to reference the column "Jobsearch.Ref". **********
    Error ********** ERROR: column "ref" does not exist SQL state: 42703
    Hint: Perhaps you meant to reference the column "Jobsearch.Ref".
    Character: 51</p>
  </blockquote>
  
  <p>(3)Here is the Select statement I can use to see the row by using the select script</p>
  
  <pre><code>SELECT "JobTitle", "Location", "Salary", "Description", "Currency", "Duration", "Ref"
      FROM "Test2 Schema"."Jobsearch";
  </code></pre>
  
  <p>I can see the data when I use the select script.I have included two print screens one showing the select statement output and the other the view row output with the error message.</p>
  
  <p><a href="https://i.stack.imgur.com/FDzcP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FDzcP.png" alt="enter image description here"></a></p>