Re: Problems on "copy" statement

On Wed, Apr 13, 2005 at 12:36:09PM -0400, Keith Worthington wrote:
>
> I vaguely remember colliding with case sensitivity in 7.3.X when I first
> started using postgresql. I changed all my table and column names to
> lowercase to avoid the issue and I haven't thought about it since. That
> appears to be changed in 8.0.0 as SELECT * FROM myschema.tbl_name; and SELECT
> * FROM MySchema.Tbl_Name; work equally well. Is this a new supported now and
> forever behavior? IT would be nice for readability and compactness to be able
> to use SalesOrder.TblDetail.ItemID instead of sales_order.tbl_detail.item_id.

This isn't new behavior. If you don't quote identifiers then they're
folded to lowercase.

test=> SELECT version();
version
---------------------------------------------------------------------------
PostgreSQL 7.2.7 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.4.2
(1 row)

test=> CREATE TABLE MyTable (myColumn text);
CREATE

test=> SELECT MYCOLUMN FROM MYTABLE;
mycolumn
----------
(0 rows)

test=> SELECT mycolumn FROM mytable;
mycolumn
----------
(0 rows)

test=> SELECT MyCoLuMn FROM mYtAbLe;
mycolumn
----------
(0 rows)

test=> \d
List of relations
Name | Type | Owner
---------+-------+-------
mytable | table | mfuhr
(1 row)

test=> \d mytable
Table "mytable"
Column | Type | Modifiers
----------+------+-----------
mycolumn | text |

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/