Sample Header Ad - 728x90

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