Re: error: table does not exist

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/

In response to

Browse pgsql-novice by date

  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