Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: inserting/updating a field with the contents of a text file
- From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
- To: Lonni J Friedman <netllama(at)gmail(dot)com>, George Pavlov <gpavlov(at)mynewplace(dot)com>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: inserting/updating a field with the contents of a text file
- Date: Mon, 24 Sep 2007 18:50:39 -0700 (PDT)
--- Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
> > (e.g. ...-c"insert into table (info) values('`sed "s/'/''/g"
> > file.txt`')" )
> >
if single quotes were your problem, then maybe you could use Postgresql's dollar sign quoting.
you could replace the ' with $myquote$.
- Follow-Ups:
- Re: inserting/updating a field with the contents of a text file
- From: Lonni J Friedman
- Re: inserting/updating a field with the contents of a text file
- References:
- Re: inserting/updating a field with the contents of a text file
- From: Lonni J Friedman
- Re: inserting/updating a field with the contents of a text file
- Prev by Date: Re: inserting/updating a field with the contents of a text file
- Next by Date: Re: inserting/updating a field with the contents of a text file
- Previous by thread: Re: inserting/updating a field with the contents of a text file
- Next by thread: Re: inserting/updating a field with the contents of a text file
- Indexes: