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 -~----------~----~----~----~------~----~------~--~---
