On Tue, 2005-07-26 at 13:54, DracKewl wrote:
> Trying out PostgreSQL for the first time and running into a minor
> problem.
> I created two tables one with the Add table wizard the other hard-core
> script.
>
> Script made table:
> Select * from Example
> --This works as expected
> Select * from EXAMPLE
> --This works as expected
>
> Wizard made table:
> Select * from Example
> --ERROR: relation "Example" does not exist
> Select * from "Example"
> --This works as expected
>
> The wizard table has created a case sensitive restriction on me and
> forced me to use quotes. How do I turn this off?
When you created the table you likely did this:
create table Example (...
While the wizard actually did this:
create table "Example" (...
So, postgresql folded case on your create table, and actually created a
table called example, while the wizard's quoting the table name meant
the table was named Example. This should fix you up:
alter table "Example" rename to example;
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
