Re: Postgres Pg_connect PHP

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: Vyacheslav Kalinin <vka(at)mgcp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Pg_connect PHP
Date: 2009-06-09 18:35:12
Message-ID: 8a547c840906091135x5e1f5e7awfd39625cdd1580d3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 9, 2009 at 11:31 AM, Vyacheslav Kalinin<vka(at)mgcp(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vyacheslav Kalinin 2009-06-09 18:41:36 Re: Postgres Pg_connect PHP
Previous Message Vyacheslav Kalinin 2009-06-09 18:31:49 Re: Postgres Pg_connect PHP