ERROR : relation "master"

[hlnet]

I am newbie. I want use query : SELECT public.Master.I D, public.Master.D escription from Master , but
->Error missing table Master

.If use query : SELECT "public"."Maste r"."ID", "public"."Maste r"."Description " from "Master"

It is OK.
SELECT "ID", "Descriptio n" from "Master". It's OK

SELECT ID, Description from "Master" . ERROR : column "id" does not exist at character 8.

SELECT ID, Description from Master . ERROR : relation "master" does not exist.

How to use query : SELECT public.Master.I D, public.Master.D escription from Master?

Help me please.

Thank you very much

[michaelb]

Hi, hinet.
Please read the Posting Guidelines at the top of the Forum and make sure to use the CODE tags when appropriate in your future postings.

As for your question you apparently created your table with case sensitive name, as well as the fields on it.
Usually this brings no benefits, but a lot of hustles; now any time you refer to your table you need to use quotes:
[CODE=sql]
SELECT public."Master" ."ID", public."Master" ."Descriptio n" from "Master" ;[/CODE]
Unless you have a good reason to keep it this way I would rename the table and column to keep them case-insensitive. It'll make your life easier.
See ALTER TABLE for details.

[hlnet]

Hi michaelb,
Thank you very much for helping
Hlnet