P.S. This might be helpful too.
I downloaded yesterday's amalgamation, backed up shell.c and then overwrote it
with your most recent version.
$ ./sqlite3 foo.db
SQLite version 3.8.0 2013-06-26 13:22:28
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table foo( col1 int, col2 varchar(255) ) ;
sqlite> .import "|gawk 'BEGIN{ for ( i = 0 ; i < 10 ; i ++ ){ print i \"| this
is row \" i } ; exit 0 ; }'" foo
sqlite> select * from foo
...> ;
0| this is row 0
1| this is row 1
2| this is row 2
3| this is row 3
4| this is row 4
5| this is row 5
6| this is row 6
7| this is row 7
8| this is row 8
9| this is row 9
> -----Original Message-----
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf
> Of Konrad Hambrick
> Sent: Thursday, June 27, 2013 4:01 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] sqlite3: .import command handles quotation incorrectly
>
> > -----Original Message-----
> > From: sqlite-users-boun...@sqlite.org
> > [mailto:sqlite-users-boun...@sqlite.org] On Behalf
> > Of Richard Hipp
> > Sent: Thursday, June 27, 2013 9:16 AM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] sqlite3: .import command handles quotation incorrectly
> >
> > On Thu, Jun 27, 2013 at 8:58 AM, Richard Hipp <d...@sqlite.org> wrote:
> >
> > >
> > > What if, instead of a new command, we simply extend the ".import" command
> > > so that if the first character of the filename is "|" it interprets the
> > > filename as a pipe instead of a file. The ".output" command works that
> > > way.
> > >
> >
> > This alternative concept has now been implemented on trunk. Example:
> >
>
> Richard --
>
> I had a chance to download shell.c and compile from trunk.
>
> A sample session is below.
>
> Thanks you very much !
>
> -- kjh
>
> sqlite> create table foo( col1 int, col2 varchar(255) ) ;
> sqlite> .import "|gawk 'BEGIN{ for ( i = 0 ; i < 10 ; i ++ ){ print i \"|
> this is row \" i
> } ; exit 0 ; }'" foo
> sqlite> select * from foo ;
> 0| this is row 0
> 1| this is row 1
> 2| this is row 2
> 3| this is row 3
> 4| this is row 4
> 5| this is row 5
> 6| this is row 6
> 7| this is row 7
> 8| this is row 8
> 9| this is row 9
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
