Re: How to know column constraints via system catalog tables - Mailing list pgsql-sql

> 
> Hi,
> 
> I need to query each column's constraint and name of a table in
> postgreSQL v7.3.4 with a single SQL query but don't know how. Would
> appreciate any pointers!
> 
> Thank you.
> 
> Regards,
> Damon
> 
select relname,conname 
from pg_constraint,pg_class 
where pg_class.oid=conrelid ;

could be start. 

Regards, Christoph