Re: Inserting file content into column

Hi Moravec,

Look at the COPY command.

Cheers
Noel

Moravec Jan wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>