> -----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
