TaKO8Ki / gobang

A cross-platform TUI database management tool written in Rust
MIT License
2.94k stars 92 forks source link

Fix JSON conversion of the table name which is also a keyword for PostgreSQL #133

Closed boozec closed 2 years ago

boozec commented 3 years ago

Hi all :wave: Similarly to escape the table name in the SELECT command query, here we escape the table name with apostrophes. In fact, to_json() raised a "Syntax error" for table that uses a keyword as its name.

An example is a table named order.