[postgis-users] ESRI Shapes from database

[Steffen Macke]

Lee,

> > 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

pg_dump is creating COPY  FROM STDIN statements by default, so you can use it
to generate some examples including escaping, etc.
Here is a an example (Note the \.) at the end:

CREATE TABLE test (
    test integer
);

COPY test (test) FROM stdin;
1
2
\.

> > 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.

COPY FROM STDIN does the same as INSERT, so you need the INSERT privilege
on the table in question.

Regards,

Steffen