Hello, One thing i'm missing in PRAGMA table_info() is that i can't specify a database name, like: PRAGMA table_info(main.mytable);
Problem: if a TEMPORARY TABLE is defined using the same name as an already existing table in the main database (which SQLITE3 apparently allows), PRAGMA table_info() returns the info for the temporary table, while the table info for the original table in the main database can't be retrieved until the temporary table is deleted. Not that i'd create such a table, but i'd like to write a small wrapper function for fetching the table info, where the caller shall choose if the info shall be taken from either the main or temp db, or any other attached database for that matter. Shouldn't be too problematic to add sucha feature? -- Cheers, Oliver 'Bloody' Lange. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
