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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
