On Thursday, August 20, 2020 at 12:34:07 PM UTC-7, Anant M wrote: > > Hi, > > Thanks for the help! I will fix the source database which is of course the > better solution, but I did want to ask as pgloader does not seem to use > identifier quoting, so I was curious as to the practice of using it and > whether it was better to use double quotes over no quotes. >
I think the general database design advice would be: don't use any identifiers where quoting would affect the query. Unfortunately, disabling quoting by default would not work well for Sequel because then using identifiers that require quoting (e.g. because they overlap with keywords or contain spaces) would break things. Additionally, not quoting results in behavior that differs across databases, since foo (unquoted) is the same as "FOO" on some databases and the same as "foo" on other databases. Sequel takes the conservative approach of quoting all identifiers. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/24d960d1-d371-4308-923d-73139eef4951o%40googlegroups.com.
