Error querying postgresql table created in pgAdmin
0
votes
2
answers
955
views
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"
Asked by haresfur
(115 rep)
Sep 22, 2020, 02:16 AM
Last activity: Sep 22, 2020, 11:09 AM
Last activity: Sep 22, 2020, 11:09 AM