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