Re: mysql load_file() function

On Feb 4, 2005, at 8:34 AM, Ben-Nes Yonatan wrote:

>> 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
>>
>
> First thanks for your answer David but im afraid that i still got a
> problem
> with this solution... im not trying to upload a big file which contain
> data
> which is supposed to be divided to plenty of rows, i want to upload a
> big
> file (wav,ppt,whatever...) into one column one row... maybe i can use
> COPY
> to upload the rows to a temp_table and then from there build the file
> at the
> primary table so it will be only postgresql working in his own
> enviroment...
> though that seem "too heavy" isnt there a better elegant solution?
>

Try looking here--again if I understand what you are trying to do....

http://www.postgresql.org/docs/8.0/interactive/largeobjects.html

Large objects in postgresql can be files, images, etc.  There are
several functions for manipulating them (loading, etc.) available in
postgresql.

Sean