Error: missing From- Clause entry for Table

Asked May 09 '18 at 17:56

Active May 09 '18 at 18:27

Viewed 603 times

I can't figure this out in postgresql:

SELECT Week1.Material, Week1.VALa, Week1.MVGavgprice, concat(Week1.Material, Week1.VALa)

FROM "Week1"

ERROR:

missing FROM-clause entry for table "week1" LINE 1: SELECT Week1.Material, Week1.VALa, Week1.MVGavgprice, concat... ^ SQL state: 42P01 Character: 8

edited May 09 '18 at 18:27

Raul Cacacho

asked May 09 '18 at 17:56

David S

Get rid of quotes around week1 – Daniel Marcus May 09 '18 at 18:02
Possible duplicate of [Are PostgreSQL column names case-sensitive?](https://stackoverflow.com/questions/20878932/are-postgresql-column-names-case-sensitive) – dmfay May 09 '18 at 18:02
1

@DanielMarcus if the table was created with the sensitivity specified he'll need to _add_ quotes around "Week1" in the `SELECT` list instead. – dmfay May 09 '18 at 18:02
hmm ok thanks @dmfay – Daniel Marcus May 09 '18 at 18:03
this didnt work: SELECT Week1.Material FROM public.Week1; – David S May 09 '18 at 18:12
you need to select from Week1 not public.week1 – Daniel Marcus May 09 '18 at 18:13
SELECT * FROM Public."Week1" works. – David S May 09 '18 at 18:15
But as soon as I do: Select Week1.Material FROM Public."Week1" FAIL – David S May 09 '18 at 18:15
ERROR: relation "sap.week1" does not exist LINE 2: FROM SAP.Week1; – David S May 09 '18 at 18:17
I change DB name to SAP – David S May 09 '18 at 18:17
Got it. For some reason, it needs quotes around "Week1"."Material" etc... – David S May 09 '18 at 18:25
Why would Postgre ask that? – David S May 09 '18 at 18:25

0 Answers0