<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Re: [Gdal-dev] OGR2OGR PG schema support</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>On Thu, 3 Mar 2005 12:32:14 +0100, Düster Horst <Horst.Duester@bd.so.ch> wrote:</FONT>
<BR><FONT SIZE=2>> Hallo</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I want to insert an ESRI shape into a postgres schema. The documentation</FONT>
<BR><FONT SIZE=2>> doesn't give any suggestions how to do that. I tried</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> ogr2ogr -f postgresql PG:... shape.shp -nln schema.table</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> but ogr2ogr responses with error</FONT>
<BR><FONT SIZE=2>> FAILED: To find existing layer `schema.table' on output dataset</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> ogr Version 1.2.1</FONT>
</P>
<P><FONT SIZE=2>Dr. Düster,</FONT>
</P>
<P><FONT SIZE=2>OGR 1.2.1 is a bit old now. The 1.2.5 (or beta 1.2.6) driver is somewhat</FONT>
<BR><FONT SIZE=2>more capable. However, it still does not have any explicit Schema support.</FONT>
<BR><FONT SIZE=2>There is an open enhancement request about this at:</FONT>
</P>
<P><FONT SIZE=2> <A HREF="http://bugzilla.remotesensing.org/show_bug.cgi?id=522">http://bugzilla.remotesensing.org/show_bug.cgi?id=522</A></FONT>
</P>
<P><FONT SIZE=2>You might want to add yourself to the cc: list. I don't know when I will get</FONT>
<BR><FONT SIZE=2>to this though. To be honest, I don't really understand how the schemas</FONT>
<BR><FONT SIZE=2>work well. </FONT>
</P>
<P><FONT SIZE=2>Best regards,</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>---------------------------------------+--------------------------------------</FONT>
<BR><FONT SIZE=2>I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com</FONT>
<BR><FONT SIZE=2>light and sound - activate the windows | <A HREF="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</A></FONT>
<BR><FONT SIZE=2>and watch the world go round - Rush | Geospatial Programmer for Rent</FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>Gdal-dev mailing list</FONT>
<BR><FONT SIZE=2>Gdal-dev@xserve.flids.com</FONT>
<BR><FONT SIZE=2><A HREF="http://xserve.flids.com/mailman/listinfo/gdal-dev">http://xserve.flids.com/mailman/listinfo/gdal-dev</A></FONT>
</P>
</BODY>
</HTML>