Select Stament Issue??

From: "DracKewl" <bradbudge(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Select Stament Issue??
Date: 2005-07-26 18:54:11
Message-ID: 1122404050.916075.37180@f14g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2005-07-26 19:39:16 Problem with text_pattern_ops
Previous Message Bricklen Anderson 2005-07-26 18:50:30 Re: