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