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
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 |