FilesExpand file tree

 master

/

table1.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

9 lines (9 loc) · 874 Bytes

 master

/

table1.sql

Top

File metadata and controls

• Code
• Blame

9 lines (9 loc) · 874 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

CREATE TABLE test(gid serial PRIMARY KEY, geom geometry);

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;POINT(0 0)'));

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;POINT(-2 2)'));

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;MULTIPOINT(2 1,1 2)'));

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;LINESTRING(0 0,1 1,1 2)'));

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;MULTILINESTRING((1 0,0 1,3 2),(3 2,5 4))'));

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;POLYGON((0 0,4 0,4 4,0 4,0 0),(1 1, 2 1, 2 2, 1 2,1 1))'));

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;MULTIPOLYGON(((1 1,3 1,3 3,1 3,1 1),(1 1,2 1,2 2,1 2,1 1)), ((-1 -1,-1 -2,-2 -2,-2 -1,-1 -1)))'));

INSERT INTO test(geom) values (GeomFromEWKT('SRID=4326;GEOMETRYCOLLECTION(POLYGON((1 1, 2 1, 2 2, 1 2,1 1)),POINT(2 3),LINESTRING(2 3,3 4))'));