On 9 Jun 2019, at 2:24pm, Igor Korot <ikoro...@gmail.com> wrote:

>> INSERT INTO tab1(blob1) VALUES(readfile('some.png'));
> 
> I presume the file extension can be anything?

As you presume, the SQLite extension does not understand the contents of the 
file.  It's treated just as a sequence of octets.  So you can use this 
extension to read files of any type you wish, including SQLite databases.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to