Please forgive me fi this is the second time you seen this today i'm sure what happened to the attempt to post this.
H2 returns unquoted identifiers in lower case which looks pretty to eye but when h2 console or SquirrelSql then wrap them in quotes cause sql exceptions of the forms "table/schema/catalog/column not found". On Mar 26, 8:12 am, Thomas Mueller <[email protected]> wrote: > Hi, > > > My table DDL is generated, and it always wraps names in double quotes > > to avoid colliding on keywords, e.g. "table_name". Then when writing > > SQL, I just use "SELECT * FROM table_name", and it has worked fine in > > postgres. > > The same collisions are possible in CREATE and SELECT. If you quote > identifiers in the CREATE TABLE statement to avoid collisions with > keywords, then you also need to wrap it in any other type of statement > (SELECT, INSERT, DELETE and so on). > > I know the list of keywords is different in each database, but I > wouldn't use double quotes because it's simpler. Just avoid keywords. > A list of common keywords is > here:http://ldbc.sourceforge.net/html/grammar.html#keywords, however there > are actually more. > > Regards, > Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
