Re: Why there is no records? - Mailing list pgsql-general

## Igor Korot (ikorot01@gmail.com):

> draft=# SELECT n.nspname, c.oid FROM pg_constraint c, pg_namespace n
> WHERE c.oid = n.oid AND c.conname = 'leagues_pkey';

Because you're joining on the wrong column, see 3rd row of
https://www.postgresql.org/docs/current/catalog-pg-constraint.html

Regards,
Christoph

-- 
Spare Space