Lines Matching refs:cmdata1

16 CREATE TABLE cmdata1(f1 TEXT COMPRESSION lz4);
17 INSERT INTO cmdata1 VALUES(repeat('1234567890', 1004));
18 \d+ cmdata1
19                                         Table "public.cmdata1"
31 SELECT pg_column_compression(f1) FROM cmdata1;
44 SELECT SUBSTR(f1, 2000, 50) FROM cmdata1;
67 INSERT INTO cmmove3 SELECT * FROM cmdata1;
76 CREATE TABLE cmdata2 (LIKE cmdata1 INCLUDING COMPRESSION);
96 UPDATE cmmove2 SET f1 = cmdata1.f1 FROM cmdata1;
114 INSERT INTO cmdata1 SELECT large_val() || repeat('a', 4000);
115 SELECT pg_column_compression(f1) FROM cmdata1;
122 SELECT SUBSTR(f1, 200, 5) FROM cmdata1;
183 CREATE MATERIALIZED VIEW compressmv(x) AS SELECT * FROM cmdata1;
190  SELECT cmdata1.f1 AS x
191    FROM cmdata1;
193 SELECT pg_column_compression(f1) FROM cmdata1;
227 CREATE TABLE cminh() INHERITS(cmdata, cmdata1);
277  SELECT cmdata1.f1 AS x
278    FROM cmdata1;
330 SELECT length(f1) FROM cmdata1;