Re: Problem with public schema

[Richard Huxton <dev@archonet.com>]

Nick Allan wrote:
> Hi all
> I've just started using postgres and have all my tables defined in the
> public schema.
> For some reason I'm being forced to use sql like the following
> select * from public."tblCategory";
> instead of 
> select * from tblCategory;

You must have defined it as:
  CREATE TABLE "tblCategory"

If you define a table using quotes, you need to quote it on access. If 
you don't define using quotes, you don't need quotes on access.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org