[postgis-users] ESRI Shapes from database

[Brent Wood]

--- Lee Keel <lee.keel at uai.com> wrote:

> > Steffen,
> 
> Thanks for the reply, but I am not sure how to call COPY using STDIN.  Do
> you have an example?  I really don't see how to call COPY using STDIN if I
> am using an npgsqlcommand object in .NET.  So I am guessing there is no
> specific permission that I can grant that will allow this?  Bummer.
> 


Hi Lee,

>From the command line, you could use:

cat <file> | psql -d <db> -c "copy <table> from STDIN;"

How this can be invoked in .net I have no idea.... but there si an example :-)

If the user who makes the connection is a postgres superuser, you should be
able to copy to/from files directly.

Another option, are there any .net bindings for GDAL/OGR?


Cheers,

   Brent Wood