PSQL - UPDATE tableA off tableB where Column1 Match

Question

I have a broken column with null values, however I have managed to import the data off a csv into TempTable

MediaRecords - localpath column is null

TempTable - localpath column is correct

UPDATE mediarecords SET localpath = TempTable.localpath FROM TempTable WHERE recordid = TempTable.recordid;

I keep getting ERROR: relation "temptable" does not exist LINE 3: FROM TempTable however I can browse the table and see the data.
I tried following this How to update selected rows with values from a CSV file in Postgres? and here we are

Answer 1

Hu Bucky, can you check how the table is actually called because I see you referring at it as TempTable with camelcase and the error states temptable all lowercase.

PostgreSQL could be case sensitive. As example if you do the following

create table "TempTableABC" (id int);

Trying to select from temptableABC will fail

defaultdb=> select * from temptableABC;
ERROR:  relation "temptableabc" does not exist
LINE 1: select * from temptableABC;
                      ^

You'll need to use the same quoted syntax to make it work

defaultdb=> select * from "TempTableABC";
 id 
----
(0 rows)

Answer 2

UPDATE mediarecords SET localpath = "TempTable".localpath
FROM public."TempTable"
WHERE "mediarecords".recordid = "TempTable".recordid;

Worked