2
create table grass_test1 (i1 integer, d1 double precision, c1 varchar(20))
5
insert into grass_test1 values ( 1, 123.456, 'abcd' )
8
insert into grass_test1 values ( 2, null, 'xxx' )
2
CREATE TABLE grass_test1 (i1 INTEGER, d1 DOUBLE PRECISION, c1 VARCHAR(20))
5
INSERT INTO grass_test1 VALUES ( 1, 123.456, 'abcd' )
8
INSERT INTO grass_test1 VALUES ( 2, null, 'xxx' )
11
select * from grass_test1
11
SELECT * FROM grass_test1
16
select c1 from grass_test1 where d1 < 500 / 2 and i1 <> 2 and c1 ~ 'bc'
16
SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1 <> 2 AND c1 LIKE '%bc%'
20
insert into grass_test1 values ( 3, 0.0, '_\''_' )
23
alter table grass_test1 add column i2 integer
26
update grass_test1 set d1 = 18.6, i2 = 987 where i1 = 2
20
INSERT INTO grass_test1 VALUES ( 3, 0.0, '_\''_' )
23
ALTER TABLE grass_test1 ADD COLUMN i2 INTEGER
26
UPDATE grass_test1 SET d1 = 18.6, i2 = 987 WHERE i1 = 2
29
select * from grass_test1
29
SELECT * FROM grass_test1
35
drop table grass_test1
35
DROP TABLE grass_test1