Proposal: functions get_text() or get_url()

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, path, content) VALUES(1, '/tmp/mytext, get_text('/tmp/mytext));
AFAIK there was a get_url in libcurl but I neither find it any more. But anyway: This should be part of the core... :->

-S.