Re: [sqlite] BLOB type not showing in table description after using create table as

Tiemogo, Idrissa wrote: > When I derive a table from another table containing blob type. > The describing the new table doesn’t show “blob". > > sqlite> create table t1 (p_id int, geometry blob); > sqlite> pragma table_info(t1); > 0|p_id|int|0||0 > 1|geometry|blob|0||0 > sqlite> create table t2 as

[sqlite] BLOB type not showing in table description after using create table as

I am using sqlite 3.8.6 on MacOSX Yosemite 10.10.2. When I derive a table from another table containing blob type. The describing the new table doesn’t show “blob". See below: sqlite> select sqlite_version(); 3.8.6 sqlite> create table t1 (p_id int, geometry blob); sqlite> pragma