single-quotes around the tablename -- it is a string not an identifier ...
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Wout Mertens >Sent: Wednesday, 15 August, 2018 00:33 >To: SQLite mailing list >Subject: Re: [sqlite] The upcoming alter table rename column > >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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users