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