[postgis-users] How to see the constraints generated by PostGIS

Ezequias Rodrigues da Rocha ezequias at recife.pe.gov.br
Wed Mar 8 10:53:07 PST 2006

Thank you Michael, it works for me.


Michael Fuhr escreveu:
> On Wed, Mar 08, 2006 at 02:52:45PM -0300, Ezequias Rodrigues da Rocha wrote:
>> I need to see the constraints generated by postgis. I did some shp2pg 
>> and now I need to see how this constraints where defined.
> In psql run "\d tablename"; if you're using some other client then
> check its documentation.  Or query the system catalogs:
> SELECT conname, contype, pg_get_constraintdef(oid, true)
> FROM pg_constraint
> WHERE conrelid = 'tablename'::regclass;

Ezequias Rodrigues da Rocha
msn:ezequias at hotmail.com
"the worst of democracies is still better than the best of dictatorship"

More information about the postgis-users mailing list