Skip site navigation (1) Skip section navigation (2)

Re: Inserting file content into column

From: Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au>
To: Moravec Jan <Jan(dot)Moravec(at)ips-ag(dot)cz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Inserting file content into column
Date: 2006-06-06 00:43:29
Message-ID: 4484CFB1.8070200@med.monash.edu.au (view raw or flat)
Thread:
Lists: pgsql-novice
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
>   


In response to

pgsql-novice by date

Next:From: Arnaud LesauvageDate: 2006-06-06 14:49:43
Subject: levenshtein contrib installation
Previous:From: Moravec JanDate: 2006-06-06 00:05:02
Subject: Inserting file content into column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group