9f8064bb创建于 2023年3月3日历史提交
--
-- CREATE_SCHEMA
--
CREATE SCHEMA foo;
NOTICE:  DDL test: type simple, tag CREATE SCHEMA
CREATE SCHEMA IF NOT EXISTS bar;
ERROR:  syntax error at or near "NOT EXISTS"
LINE 1: CREATE SCHEMA IF NOT EXISTS bar;
                         ^
CREATE SCHEMA baz;
NOTICE:  DDL test: type simple, tag CREATE SCHEMA
-- Will not be created, and will not be handled by the
-- event trigger
CREATE SCHEMA IF NOT EXISTS baz;
ERROR:  syntax error at or near "NOT EXISTS"
LINE 1: CREATE SCHEMA IF NOT EXISTS baz;
                         ^
CREATE SCHEMA element_test
  CREATE TABLE foo (id int)
  CREATE VIEW bar AS SELECT * FROM foo;
NOTICE:  DDL test: type simple, tag CREATE SCHEMA
NOTICE:  DDL test: type simple, tag CREATE TABLE
NOTICE:  DDL test: type simple, tag CREATE VIEW