sql-builder icon indicating copy to clipboard operation
sql-builder copied to clipboard

Published 20 hours ago • verified publisher icon manyuanrong

Backtick is not SQL standard / doesn't work with PostgreSQL

Open jakajancar opened this issue 4 years ago • 1 comments

The SQL:1999 standard specifies that double quote (") (QUOTATION MARK) is used to delimit identifiers. The backtick doesn't work with PostgreSQL.

jakajancar avatar Mar 14 '20 01:03 jakajancar

Whereas the value identifier should be the single quote.

jakajancar avatar Mar 14 '20 01:03 jakajancar