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
