[postgis-users] Are there psql command for detecting geometry types stored in PostGIS?

[Paul Ramsey]

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 c.relname = 'countries' and a.attnum > 0;



> On Sep 20, 2019, at 8:22 AM, Shaozhong SHI <shishaozhong at gmail.com> wrote:
> 
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users