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).

(1)Here is the create Table Statement

-- 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;

(2)Here is the error message I get when try to view all rows

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

(3)Here is the Select statement I can use to see the row by using the select script

SELECT "JobTitle", "Location", "Salary", "Description", "Currency", "Duration", "Ref"
    FROM "Test2 Schema"."Jobsearch";

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.