Dear shao,
you are now really overstepping the limits of what is considered good email
list etiquette: you are not supposed to use such a list for asking questions
that can be found in the information already available in the public
information sources coming with the software.
This
Thanks. I will have a close look. Regards, shao
On Friday, 20 September 2019, James Klassen wrote:
> Alternatively, if are asking about the type of a particular geometry
> value versus the column type in a table definition:
>
> https://postgis.net/docs/ST_GeometryType.html
>
> or
>
>
Alternatively, if are asking about the type of a particular geometry value
versus the column type in a table definition:
https://postgis.net/docs/ST_GeometryType.html
or
https://postgis.net/docs/ST_IsCollection.html
On Fri, Sep 20, 2019, 10:32 Paul Ramsey wrote:
> Also better that
Also better that geometry_typmod_out, some utility functions:
postgis_typmod_dims(integer)
RETURNS integer
postgis_typmod_srid(integer)
RETURNS integer
postgis_typmod_type(integer)
RETURNS text
> On Sep 20, 2019, at 8:30 AM, Paul Ramsey wrote:
>
> Here’s a starting point:
>
>
Here’s a starting point:
select
c.relname,
t.typname,
case when t.typname = 'geometry' then geometry_typmod_out(atttypmod) else ''
end,
a.attnum, a.attname, a.atttypid, a.atttypmod
from pg_class c join pg_attribute a on c.oid = a.attrelid join pg_type t on
a.atttypid = t.oid
where
Hi, All,
Are there psql command for detecting geometry types stored in PostGIS?
For instance, data is stored in the geometry column, can we use any
commands to detect what types of geometry it is (e.g., collection of
points, or point only and etc.)?
Regards,
Shao