>
> >
> > i've got some tables where constraints don't have an explicit name,
> how can
> > i drop them.
> >
>
> Refer to the system catalogs section within the documentation.
> pg_relcheck keeps track of constraints.
>
>
More precisely
select relname , rcname from pg_class join pg_relcheck on (
pg_relcheck.rcrelid = pg_class.oid ) ;
Regards, Christoph