Relation XX does not exist - Mailing list pgsql-general

Hi Guys,

Just started using PG today, bought the book and all was cruising along well untill i got the following error:

Relation 'jobdetails' does not exist

when i issued:

INSERT INTO jobdetails (jobDetailsID, jobID, claimName , claimNumber ,placementDate , completionDate, invType ,
insType)values  
(7, 72,'P1234','Mr T',986453483,988639200, 'S', 'W')

All seems to be right here:

impmp=> \d
         List of relations
      Name      |   Type   | Owner
----------------+----------+-------
 jobDetails     | table    | impmp
 jobdetails_seq | sequence | impmp
 jobs           | table    | impmp
 jobs_seq       | sequence | impmp
(4 rows)

Any clues ? Ive restarted the SQL server and to no avail.

Thanks.
Matt