On Monday 29 March 2004 14:17, Cyrille Gautard wrote:
> Hello,
>
> I have a postgresql database and it might be update with a xml file. I
> want to write an extension to SQL (the function update_from_xml) which
> be call in a client program. The xml file will not be passed as a
> postgresql argument to the function because it is an external file.
>
> How can I do to get rid of this problem ? If it's not possible, do you
> have another solution ?
You perhaps want to look at the large-object support in PG.
However, if the xml file is not readable by the database backend you are going
to have to pass it through the client anyway.
PS - there is some xml-related stuff in the contrib/ directory of the source
distribution. Don't know if any of it is of use to you.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
