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.