[postgis-users] help setting up postgis
Jan Saalbach
fire at dubmosphere.de
Tue Aug 10 06:37:23 PDT 2010
thank you for your help. And yet I have another question. When I try
to insert my 3d points into a previously created, empty column it
seems only a 2d point is stored. Here is what I did via psql:
-----
postgisdb=# INSERT INTO punkte (jan) VALUES (ST_makePoint(1.1,2.2,3.3));
INSERT 0 1
postgisdb=# SELECT * FROM punkte;
id | jan
----+------------------------------------------------------------
| 01010000809A9999999999F13F9A999999999901406666666666660A40
(1 Zeile)
postgisdb=# SELECT
ST_AsText('01010000809A9999999999F13F9A999999999901406666666666660A40');
st_astext
----------------
POINT(1.1 2.2)
(1 Zeile)
-----
In the last line only two dimensions are returned but I would have
expected three. Any suggestions what I am doing wrong or how I can
visualise the third one? At the moment I am learning the psql commands
and postgis structure simultaneously, so please forgive me if I am
missing anything simple.
Regards,
Jan
More information about the postgis-users
mailing list