Re: Problem with public schema

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: "Nick Allan" <allanni(at)rvib(dot)org(dot)au>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problem with public schema
Date: 2004-05-21 15:05:08
Message-ID: m3ad014y8r.fsf@conexa.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Nick Allan" <allanni(at)rvib(dot)org(dot)au> writes:

> I get the following error
>
> ERROR:  Relation "tblcategory" does not exist
>
> Anyone got any suggestions on what I'm missing here?

Try adding the quotes, like in public."tblCategory", for instance

SELECT * FROM "tblCategory"

Regards,
Manuel.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Manuel Sugawara 2004-05-21 15:10:10 Re: Update Row Level Trigger: default value for update trigger
Previous Message Joe Erickson 2004-05-21 12:40:06 Re: New from mssql. Help please