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
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 table_info
2 matches
Mail list logo