[postgis-users] ESRI Shapes from database
sdteffen at gmail.com
Sat Oct 20 00:24:26 PDT 2007
> > 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 (
COPY test (test) FROM stdin;
> > 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.
More information about the postgis-users