Kees Nuyt wrote:
> It conforms to the SQL standard, you can use the Postgresql docs
> as a reference.
Actually, neither SQLite nor PostgreSQL conform to the SQL standard.
The SQL standard requires that delimited identifiers are case sensitive
and can contain double quotes, and that undelimited identifiers are
folded to upper case.
SQLite's identifiers never are case sensitive.
PostgreSQL folds undelimited identifiers to lower case, and does not
allow double quotes inside a delimited identifier.
sqlite-users mailing list