By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,530 Members | 891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,530 IT Pros & Developers. It's quick & easy.

ERROR : relation "master"

P: 3
I am newbie. I want use query : SELECT public.Master.ID, public.Master.Description from Master , but
->Error missing table Master

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

It is OK.
SELECT "ID", "Description" 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.ID, public.Master.Description from Master?

Help me please.

Thank you very much
Aug 19 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 534
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:
Expand|Select|Wrap|Line Numbers
  1. SELECT public."Master"."ID", public."Master"."Description" from "Master" ;
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.
Aug 20 '07 #2

P: 3
Hi michaelb,
Thank you very much for helping
Aug 22 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.