Re: error: table does not exist - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: error: table does not exist
Date
Msg-id 20030811091515.X76525-100000@megazone.bigpanda.com
Whole thread Raw
In response to error: table does not exist  (jun queano <jun@sigmaksa.com>)
List pgsql-novice
On Mon, 11 Aug 2003, jun queano wrote:

> Using pgAdminII (vb version) i encountered this problem:
>
> SQL syntax to add a single record as a manner of testing:
> "INSERT INTO
> Table1(Age,EmployeeName,Gender,Address1,Address2,Company,Designation,License)
> "VALUES ('26','jun','m','add1','add2','sttb','sf','1234')"

INSERT INTO "Table1" ...

For non-all lower case names, if you quoted it when you
made the object, you'll need to quote it when you refer
to it.  The same may apply to your column names if you
quoted those on the create as well.


pgsql-novice by date:

Previous
From: jun queano
Date:
Subject: error: table does not exist
Next
From: Bryan Bulten
Date:
Subject: Re: error: table does not exist