blob: 2ae4e2d225e5f41b262ca9be449400f83eb52895 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
--
-- CREATE_VIEW
--
CREATE VIEW static_view AS
SELECT 'foo'::TEXT AS col;
NOTICE: DDL test: type simple, tag CREATE VIEW
CREATE OR REPLACE VIEW static_view AS
SELECT 'bar'::TEXT AS col;
NOTICE: DDL test: type simple, tag CREATE VIEW
NOTICE: DDL test: type alter table, tag CREATE VIEW
NOTICE: subcommand: REPLACE RELOPTIONS
CREATE VIEW datatype_view AS
SELECT * FROM datatype_table;
NOTICE: DDL test: type simple, tag CREATE VIEW
CREATE RECURSIVE VIEW nums_1_100 (n) AS
VALUES (1)
UNION ALL
SELECT n+1 FROM nums_1_100 WHERE n < 100;
NOTICE: DDL test: type simple, tag CREATE VIEW
|
