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

[Ezequias Rodrigues da Rocha]

Thank you Michael, it works for me.

Ezequias

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
http://ezequiasrocha.blogspot.com
msn:ezequias at hotmail.com
"the worst of democracies is still better than the best of dictatorship"