I have successfully created a table in pgAdmin which generated the code:
CREATE TABLE public."Test3" ( "PID" integer, "Name" character varying(20), PRIMARY KEY ("PID") ) TABLESPACE pg_default; ALTER TABLE public."Test3" OWNER to postgres;
However when I try to query the table with:
Select * from Test3;
I get the error:
ERROR: relation "test3" does not exist LINE 1: Select * from Test3; ^ SQL state: 42P01 Character: 15
Same thing happens if I leave out the TABLESPACE line. Same thing happens if I try to query a table after importing rows from a .csv file. Seems like I must be missing something obvious.
Edit: I am trying to create the table in a database named "ABR"