You can, since 3.16, get most pragma results as table-valued functions. I
think what you want is something like
SELECT * FROM pragma_table_info("tableName");
On Wed, Aug 15, 2018 at 8:04 AM Domingo Alvarez Duarte <mingo...@gmail.com>
wrote:
> Hello Richard !
>
> I'm following the changes you are making to a add "alter table rename
> column" capability to sqlite and I think that it's a good moment to add
> a new system table for the columns (I know that we can somehow get this
> info now with "pragmas") this way we can get/use this info using "SQL"
> aka "data dictionary". Probably if sqlite already provided this facility
> less low level changes would be needed to this task ("rename column")
> and others.
>
> A simplified version of
> https://www.postgresql.org/docs/10/static/catalog-pg-attribute.html
> would be nice.
>
> Cheers !
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
