Paul,<br><br>PgSql is not the only driver that use the schema.table notation. I see that OGR's MSSQLSpatial driver too uses it too. So there won't be anything new. On the other hand, the '\' separator could lead to some confusion with escaping in some situations.<br>
<br><div class="gmail_quote">On Tue, May 31, 2011 at 10:13 PM, Paul Ramsey <span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
This is why I'm looking for guidance from the OGR experts... what<br>
layer name styles work best for interoperation? If I emit schema.table<br>
layers on read, will apps be happy or sad?<br>
<br>
The driver is moving towards read/write. I will have no trouble<br>
dealing with schema.table names as I can just map them to<br>
\FeatureDataset\FeatureClass under the covers, and create new<br>
FeatureDataset folders as necessary.<br>
<font color="#888888"><br>
P.<br>
</font><div><div></div><div class="h5"><br>
On Tue, May 31, 2011 at 5:05 AM, Duarte Carreira <<a href="mailto:DCarreira@edia.pt">DCarreira@edia.pt</a>> wrote:<br>
> Paul,<br>
><br>
> The schema.table is the most similar to the structure of the fgdb, but may be unwanted complexity. Can this be an option? Like "yes, consider the dataset name"? Or "no, discard dataset name". I can see myself in both situations...<br>
><br>
> Is the driver read only? If not, what will happen when you try the reverse? From PgSql to fgdb?<br>
><br>
> Duarte<br>
><br>
> -----Mensagem original-----<br>
> De: Paul Ramsey [mailto:<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>]<br>
> Enviada: segunda-feira, 30 de Maio de 2011 22:47<br>
> Para: <a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
> Assunto: [gdal-dev] Table Names (FGDB)<br>
><br>
> So, my goal is to map information from FGDB to PostGIS and as much<br>
> fidelity as possible.<br>
><br>
> FGDB includes a class called "Feature Dataset" which is basically a<br>
> folder that holds "Feature Class" objects, which map directly to OGR<br>
> layers. So the "Feature Dataset" then acts a good deal like a schema<br>
> in PostGIS.<br>
><br>
> I've noticed that the PgSQL driver supports a SCHEMA keyword to allow<br>
> you to write to a schema without schema-qualified table names, and<br>
> that it also notices when table names are schema qualified and puts<br>
> them in the appropriate place. So the name of a layer read from a<br>
> schema would show up in OGR as "schemaname.tablename".<br>
><br>
> In FGDB, we have the "path" of a Feature Class or Table, which looks<br>
> like this \FeatureDataset\FeatureClass. Similar to the schema<br>
> qualification, yet different. As it stands right now, the<br>
> FeatureDataset portion of the path is discarded in the public API, so<br>
> that the OGR layer name is just the FeatureClass, with no reference to<br>
> the FeatureDataset. That makes it hard to create a mapping from FGDB<br>
> (\FeatureDataset\FeatureClass) to PostGIS<br>
> (FeatureDataset.FeatureClass).<br>
><br>
> The FGDB implementation currently returns "GeoDatabase.GetQueryName()"<br>
> as the layer name, which "Gets the query name (the name to use in SQL<br>
> statements) of a table based on its path". If it returned the path<br>
> name, then the FeatureDataset qualification information could be<br>
> preserved in other contexts. On the other hand, perhaps the QueryName<br>
> is more useful to more users than the path? It looks like the<br>
> QueryName is expected to be unique, so probably FeatureClass and Table<br>
> names have to be unique regardless of what FeatureDataset they appear<br>
> in (true?).<br>
><br>
> So my options are:<br>
><br>
> (a) - change the current OGR layer name to the path name<br>
> (b) - change the current OGR layer name to a "schema.table" analogue<br>
> and handle appropriately<br>
> (c) - leave the current OGR layer name as is ("tablename" regardless<br>
> of containing folders) and make a FGDB-only method for accessing the<br>
> pathname for my particular purposes<br>
><br>
> Preferences?<br>
><br>
> P.<br>
><br>
><br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br>/tʃaɪθənjə/ /kʊmɑr/ <br>+91-9494447584<br>17.2416N 80.1426E<br>