[postgis-users] how to determine a geometry type?

Luís de Sousa luis.a.de.sousa at gmail.com
Mon Jul 5 01:58:46 PDT 2010

Hi nguyen,

You can use a query like this:

SELECT t.relname,
  FROM pg_class t,
       pg_constraint c
 WHERE t.oid = c.conrelid
   AND c.conname LIKE '%enforce_geotype%'
   AND t.relname LIKE 'mytable';

Hope it helps,


More information about the postgis-users mailing list