Re: Why there is no records?

Christoph Moench-Tegeder <cmt@burggraben.net>

From: Christoph Moench-Tegeder <cmt@burggraben.net>
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-02-17T00:03:43Z
Lists: 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