From: | Bryan Bulten <bbulten(at)uvic(dot)ca> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: error: table does not exist |
Date: | 2003-08-11 16:34:09 |
Message-ID: | 20030811093409.17fa6f11.bbulten@uvic.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> the thing that confuses me is that i have created the table and named
> it "Table1" with respective columns as mentioned above. all column
> data types are set to "text[]"
By quoting a table name during creation, the name becomes case
sensitive. With case sensitive names that have uppercase characters,
you must always quote them - otherwise they are forced lowercase (as
could be seen in the error message.) So this should fix the problem:
INSERT INTO "Table1" (Age, EmployeeName, Gender, Address1, Address2,
Company, Designation, License)
VALUES ('26', 'jun', 'm', 'add1', 'add2', 'sttb', 'sf', '1234')
--
Bryan Bulten
http://www.bulten.ca/
http://wxnet.sourceforge.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Hihn | 2003-08-12 17:49:29 | Re: Auto_Increment |
Previous Message | Stephan Szabo | 2003-08-11 16:26:47 | Re: error: table does not exist |