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.
