Dear sqlite developers, I have noticed that the .dump command quotes the table name on INSERT commands, but does not quote them on CREATE TABLE commands.
Import operations using the generated SQL into Postgresql fails unless one manually edits the SQL to quote mixed case or upper case table names in CREATE TABLE commands prior to importing into Postgres, because Postgres is case-insensitive unless the names are quoted. Possible resolution: Modify output syntax for CREATE TABLE generation for .dump and .schema to quote all table names. Cheers, Doug Campbell _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
