| 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: | Whole Thread | Raw Message | 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 |