Re: [gnome-db] Per-table meta-data with capital letters in the table name?

[Vivien Malerba <vmalerba gmail com>]

2009/7/1 Murray Cumming <murrayc murrayc com>

On Wed, 2009-07-01 at 10:19 +0200, Vivien Malerba wrote:
> For SQL identifiers you don't care how they are represented as long
> as they represent the correct object: for example the *myTable* object
> is
> the same as the *mytable* object (I used asterixes to avoid any
> confusion
> with double quotes).

Are you sure? Is this specified somewhere?

Surely these refer to different tables?

SELECT * FROM "mytable"
SELECT * FROM "MyTable"

I used asterixes, not double quotes, so I was saying that
SELECT * FROM mytable
SELECT * FROM MyTable
are the same