Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group