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

[Luís de Sousa]

Hi nguyen,

You can use a query like this:

SELECT t.relname,
       c.consrc
  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,

Luís