postgis使用wkt或wkb创建几何_postgresql st_geomfromwkb

• 使用wkt创建 ST_GeomFromText
• 使用wkb创建 ST_GeomFromWKB
• 导出为wkt ST_AsText
• 导出为wkb ST_AsEWKB

postgres=# select ST_AsEWKB(ST_GeomFromWKB ('\x0101000020e6100000dfc0e44691145d40e355d636c5fb4340', 4326 ));
警告:  OGC WKB expected, EWKB provided - use GeometryFromEWKB() for this
                      st_asewkb
------------------------------------------------------
 \x0101000020e6100000dfc0e44691145d40e355d636c5fb4340
(1 行记录)


postgres=# select ST_AsText(ST_GeomFromWKB ('\x0101000020e6100000dfc0e44691145d40e355d636c5fb4340', 4326 ));
警告:  OGC WKB expected, EWKB provided - use GeometryFromEWKB() for this
          st_astext
-----------------------------
 POINT(116.321367 39.966956)
(1 行记录)


postgres=# select ST_AsEWKB(ST_GeomFromText ('POINT(116.321367 39.966956)', 4326 ));
                      st_asewkb
------------------------------------------------------
 \x0101000020e6100000dfc0e44691145d40e355d636c5fb4340
(1 行记录)


postgres=# select ST_AsText(ST_GeomFromText ('POINT(116.321367 39.966956)', 4326 ));
          st_astext
-----------------------------
 POINT(116.321367 39.966956)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27