On Tue, Jun 9, 2009 at 11:31 AM, Vyacheslav Kalinin<v...@mgcp.com> wrote: >> however the COPY >> command requires superuser and I really don't want to open up the DB >> from a remote system with Superuser access. > > COPY FROM STDIN does not need superuser privileges. >
Thanks guys, the problem with copy from or to is that it creates an array and thus puts a load of stuff in memory, it's possible the file will get huge and I can't take that memory hit. I'll look again and see if I missed something Thanks Tory -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
