Hello,
usually sql identifiers are case insensitive. There are exception. If
you use double quotes for sql identifier, then you have to write exact
same identifier everywhere.
postgres=# create table Foo(a integer);
CREATE TABLE
Time: 174,078 ms
postgres=# select * from Foo;
a
---
(0 rows)
Time: 33,255 ms
postgres=# select * from foo;
a
---
(0 rows)
Time: 0,822 ms
postgres=# drop table foo;
DROP TABLE
Time: 34,945 ms
postgres=# create table "Foo"(a integer);
CREATE TABLE
Time: 3,225 ms
postgres=# select * from foo;
ERROR: relation "foo" does not exist
LINE 1: select * from foo;
^
postgres=# select * from Foo;
ERROR: relation "foo" does not exist
LINE 1: select * from Foo;
^
postgres=# select * from "Foo";
a
---
(0 rows)
Time: 1,277 ms
you cannot change this behave. Just don't use double quotes in create
statement.
Regards
Pavel Stehule
2010/2/2 Kelly SACAULT <kelly.saca...@gmail.com>:
>
> The following bug has been logged online:
>
> Bug reference: 5308
> Logged by: Kelly SACAULT
> Email address: kelly.saca...@gmail.com
> PostgreSQL version: 8.4.2
> Operating system: Ubuntu 9.10
> Description: How to disable Case sensitivity on naming identifiers
> Details:
>
> I have installed Postgresql using Ubuntu Synaptic.
>
> In the contrary of what is stated in the official manual, I have to write
> case sensitive SQL statements in my postgresql connexion.
>
> What parameter do I have to change in the postgresaql configuration ? I have
> spent many hours in studying the parameters, the faqs and the forums. I have
> found nothing to make my SQL statements case-insensitive.
> I want to be able to execute successfully such stmts:
>
> SELECT col1 FROM myTABLE
>
> SELECT Col1 FROM myTable
>
> please, may you help ?
>
> Kelly
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
