Inserting file content into column - Mailing list pgsql-novice

From Moravec Jan
Subject Inserting file content into column
Date
Msg-id D2BB392CF0C67542891FD639B93325761D1DED@pex2.corp
Whole thread Raw
Responses Re: Inserting file content into column  (Noel Faux <noel.faux@med.monash.edu.au>)
List pgsql-novice
Hello,
 
Is there a built-in function that reads the contents of a (textual) file which could then be inserted into a given
(varchar)column. What I am after is something like:
 
 
insert into cert ( cert_id,...., x509_data ) values ( nextval('seq_cert'), ...., load_file('./ca/mycert.pem') );
 
I need to do that from a DB init SQL script rather then from an application.
 
Thanks you,
Jan Moravec
 
 

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Display large object from database
Next
From: Noel Faux
Date:
Subject: Re: Inserting file content into column