Hi,

I just check PostGIS. Create a table with name test.test in test schema. The result looks so:
CREATE TABLE test."test.test"
(
  id serial NOT NULL
);

Also, if schema name have spaces it'll be look like: "test test"."test.test".

And what about other DBs?

Best regards,
    Dmitry

26.01.2015 23:49, Jukka Rahkonen пишет:
Even Rouault <even.rouault <at> spatialys.com> writes:

Hi,

This is a call for discussion on the new "RFC 52 - Strict OGR SQL quoting",
based on an older ticket.

http://trac.osgeo.org/gdal/wiki/rfc52_strict_sql_quoting

Summary :

This RFC proposes that OGR SQL enforces strict quoting rules for SQL literals
and identifiers.
Hi,

Could there be a need to think about the "schema"."table" structure? I have
some memories about (silly) users having table names with dots like
"MY.TABLE". If I remember right, with some database the SQL query

SELECT "field" FROM "MY.TABLE"

was being interpreted wrongly as "select field named 'field' from table
named 'table' from schema named 'my'".

I do not really know if this trouble belongs to GDAL at all but I share my
weigh memories anyhow.

-Jukka Rahkonen-

_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev



_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to