Re: Add \i option to bring in the specified file as a quoted literal - Mailing list pgsql-hackers

From Piotr Marcinczyk
Subject Re: Add \i option to bring in the specified file as a quoted literal
Date
Msg-id 1385418491.18347.7.camel@centos
Whole thread Raw
In response to Re: Add \i option to bring in the specified file as a quoted literal  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Fri, 2013-11-22 at 09:54 -0300, Alvaro Herrera wrote:
> Amit Kapila escribió:
> > On Fri, Nov 22, 2013 at 1:33 AM, Alvaro Herrera
> > <alvherre@2ndquadrant.com> wrote:
> 
> > > \ib homer ~/photos/homer.jpg
> > > insert into people (name, photo) values ('Homer', :homer);
> > 
> >  Isn't something similar already supported as mentioned in docs:
> > 
> > One example use of this mechanism is to copy the contents of a file
> > into a table column. First load the file into a variable and then
> > interpolate the variable's value as a quoted string:
> > 
> > testdb=> \set content `cat my_file.txt`
> > testdb=> INSERT INTO my_table VALUES (:'content');
> > 
> > or do you prefer an alternative without any kind of quote using \ib?
> 
> If the only use case of the feature proposed in this thread is to load
> stuff from files to use as column values, then we're pretty much done,
> and this patch is not needed -- except, maybe, that the `` is unlikely
> to work on Windows, as already mentioned elsewhere.  But if the OP had
> something else in mind, let's hear what it is.
> 
I've test set command mentioned above, and I think it is enough. At this
moment I see no point in implementing new command.

Best Regards
Piotr Marcinczyk




pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: [GENERAL] pg_upgrade ?deficiency
Next
From: Merlin Moncure
Date:
Subject: Re: Put json type into alphabetical order in manual table