邪悪なSQL

PostgreSQLって二重引用符で名標を囲うと、かなりフリーダムなことになるから、絶対にPJでは使わせまいと思ったのでした。

test=# CREATE TABLE " " ( "  " int, "   " text);
CREATE TABLE
test=# \d " "
       Table "public. "
 Column |  Type   | Modifiers
--------+---------+-----------
        | integer |
        | text    |

test=# INSERT INTO " " ("  ", "   ") VALUES (0, '000');
INSERT 0 1
test=# SELECT "  ", "   " FROM " ";
    |
----+-----
  0 | 000
(1 row)

test=#
test=# CREATE TABLE " TRUNCATE TABLE "" "" " ( "integer" int, "text" text);
CREATE TABLE
test=# \d " TRUNCATE TABLE "" "" "
Table "public. TRUNCATE TABLE " " "
 Column  |  Type   | Modifiers
---------+---------+-----------
 integer | integer |
 text    | text    |

test=#