"Cristian Prieto" <cristian@xxxxxxxxxxxxxxx> writes:
> The book says:
> [snip]
> But my table name Grupos is not a reserved keyword, so SELECT * FROM Grupos;
> should work, right??? but guess what... It doesn't work too... I need to
> pass SELECT * FROM "Grupos";
You didn't read far enough:
Quoting an identifier also makes it case-sensitive, whereas unquoted
names are always folded to lower case. For example, the identifiers FOO,
foo, and "foo" are considered the same by PostgreSQL, but "Foo" and
"FOO" are different from these three and each other.
Had you originally created the table as Grupos without quotes, then you
could refer to it as Grupos without quotes. But you evidently created
it with quotes (or used a tool that added quotes for you) and now you're
stuck with using quotes forevermore, unless you rename the table.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
