Ok.
But again: There is a library mentioned and documented in the famous
PostgreSQL book from Douglas & Douglas called pgcurl (
http://gborg.postgresql.org/project/pgcurl/ ). Where's this gone?
Yours, S.
2009/5/20 Robert Haas
> On Wed, May 20, 2009 at 6:34 AM, Stefan Keller wrote:
> > Questions
On Wed, May 20, 2009 at 6:34 AM, Stefan Keller wrote:
> Questions: Don't see, why this would be a security issue: How could such a
> function do any harm? large files?
No, large files aren't the problem. The problem is that the
PostgreSQL server process may have rights to access things that the
Tom,
> Apparently you've not found pg_read_file() ?
Thanks a lot. Did'nt find this. This helped!
Still, get_url() would be handy too... :->
Questions: Don't see, why this would be a security issue: How could such a
function do any harm? large files?
Finally: Got some tricky followup questions r
Robert Haas writes:
> On Mon, May 18, 2009 at 4:03 PM, Stefan Keller wrote:
>> I'd expect functions like get_text() or get_url() in order to do the
>> following:
>> INSERT INTO collection(id, path, content) VALUES(1, '/tmp/mytext,
>> get_text('/tmp/mytext));
Apparently you've not found pg_read_f
On Mon, May 18, 2009 at 4:03 PM, Stefan Keller wrote:
> How to insert a text file into a field in PostgreSQL?
> I'd like to insert a row with fields from a local or remote text file.
> I'd expect functions like get_text() or get_url() in order to do the
> following:
> INSERT INTO collection(id, pa
