Re: mysql load_file() function - Mailing list pgsql-general

From David Fetter
Subject Re: mysql load_file() function
Date
Msg-id 20050204075823.GA28646@fetter.org
Whole thread Raw
In response to mysql load_file() function  (Ben-Nes Yonatan <da@canaan.co.il>)
List pgsql-general
On Fri, Feb 04, 2005 at 09:27:08AM +0200, Ben-Nes Yonatan wrote:
> Hi all,
>
> Does anyone know if PostgreSQL got a function which work like
> load_file() of mySQL?

I am not quite sure what load_file() does, but check the COPY command
and the analgous \copy in psql.  As with many other PostgreSQL
commands, COPY has a man page in lower case:

man copy

> 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

Consider getting PostgreSQL 8.0.1 (or whatever the latest is when you
get this message ;)

> 3. Apache 1.3.26
>
> Thanks in advance,
>    Ben-Nes Yonatan
>

HTH :)

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Applications that leak connections
Next
From: "Julian Scarfe"
Date:
Subject: Re: pgpool 2.5b2 released