Slide 31
Slide 31 text
変な SQL が書けるので楽しい(違
● 実案件でこんなクエリ書いたらだめだょ
testdb=# CREATE TABLE TRUNCATE ("SELECT" text, "INSERT" text, "DELETE" text);
CREATE TABLE
testdb=# \d TRUNCATE
Table "public.truncate"
Column | Type | Collation | Nullable | Default
--------+------+-----------+----------+---------
SELECT | text | | |
INSERT | text | | |
DELETE | text | | |
testdb=# INSERT INTO TRUNCATE VALUES ('SELECT', 'INSERT', 'DELETE');
INSERT 0 1
testdb=# SELECT"SELECT"SELECT, "INSERT"UPDATE, "DELETE"TRUNCATE FROM TRUNCATE DROP;
select | update | truncate
--------+--------+----------
SELECT | INSERT | DELETE
(1 row)
PostgreSQL 14