1. COPY <table> FROM <file> [USING DELIMITERS <delim>]
This command will copy data from a file using the optional field/record
delimiter to a sqlite table.
Can I also copy from a sqlite table to a file? COPY <table> TO <file> does not work or is not implemented.
I am sure I can write some C/C++ code to do this but It would be nice
to do this in one line of code...
There is no COPY TO. There are commands in the shell program that cover that functionality. You can steal code from there, if you want.
2. Authorization
There is a module called auth.c that seems to implement some kind of
authorization that
could implement GRANT/REVOKE. Does anybody know how this works??? I cannot find an explanation in the
documentation...
There are detailed comments in sqlite.h. For an example of usages, search for sqlite_set_authorizer in CVSTrac sources in
http://www.cvstrac.org/cvstrac/getfile/cvstrac/db.c
CVSTrac uses this function to prevent people from writing reports that access the USER.PASSWD column of the database.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
