mysql load_file() function

From: Ben-Nes Yonatan <da(at)canaan(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: mysql load_file() function
Date: 2005-02-04 07:27:08
Message-ID: 420323CC.2070508@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Does anyone know if PostgreSQL got a function which work like
load_file() of mySQL?
I need it for uploading of big files... i encounter a memory limit when
i try to upload a query with the file data in it and i recieved this
response for a question about it at php-general maillist:
"load_file() is mysql internal function. the file is read by mysql
server, so it completely bypass php and also client libraries. you need
to have file priviledge."
Or maybe there is another way to upload big queries without running off
the memory limit?

Another recommendation that i received is to just upload the files to
the file system... but then ill lose the integrity of the database
(though i can make safety checks to know that everything is as it should
be) so i prefer to find a way to insert it to the DB.

My server is as follows:
1. PHP 4.3.9
2. DB - Postgresql 7.4
3. Apache 1.3.26

Thanks in advance,
Ben-Nes Yonatan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Schmid 2005-02-04 07:32:28 Re: Start problem on OSX
Previous Message Joshua D. Drake 2005-02-04 06:25:23 Re: REPLICATION Solution for WINDOWS OS