Hi,

I have made some tests for tablenames in PostgreSQL.

This works (name without delimiter):
create table Abc ( id int );
select * from abc;
select * from ABC;
select * from abC;
---
This causes problems:
create table "Def" ( id int );
select * from "Def"; // this is ok!

--Problems:
--select * from Def;
--select * from def;

-- But if you write (in lower case) this works:
create table "ghi" ( id int );
select * from ghi;
select * from Ghi;
select * from GHI;

Please, can somebody test this with other DBMS?

Thanks.

Uwe

------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to