Re: Postgres Pg_connect PHP - Mailing list pgsql-general

From Tory M Blue
Subject Re: Postgres Pg_connect PHP
Date
Msg-id 8a547c840906091135x5e1f5e7awfd39625cdd1580d3@mail.gmail.com
Whole thread Raw
In response to Re: Postgres Pg_connect PHP  (Vyacheslav Kalinin <vka@mgcp.com>)
Responses Re: Postgres Pg_connect PHP  (Vyacheslav Kalinin <vka@mgcp.com>)
List pgsql-general
On Tue, Jun 9, 2009 at 11:31 AM, Vyacheslav Kalinin<vka@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

pgsql-general by date:

Previous
From: Vyacheslav Kalinin
Date:
Subject: Re: Postgres Pg_connect PHP
Next
From: Vyacheslav Kalinin
Date:
Subject: Re: Postgres Pg_connect PHP