Re: Relation XX does not exist

Hi,

Its all good ... any table name or column with a Cpaital letter in it needs to be enclosed in "" 's ...

Just out of curiostiy, which way do you guys do it?

jobdetails
job_details
or
"jobDetiails"

Thanks,

Matt

On Thu, Apr 05, 2001 at 06:01:54AM +0100, Ryan Mahoney wrote:
> Try using quotes, ie: INSERT INTO "TableName" VALUES......
>
> does that work?
>
> -r
>
*snip*
> > > > > >
> > > > > > 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.
> > > > > >