Re: Can't drop table (repost) - Mailing list pgsql-admin

Jeremy Buchmann <jeremy@wellsgaming.com> writes:
> Okay great, but how do I know what tables I need to drop if it just gives me
> a number?  That 'xxxxxxx' is just some number like '8892659'.  Where is the
> mapping from number->name?

select relname from pg_class where oid = '8892659';

More recent versions do provide the relation name instead of number
in that error message, btw.

            regards, tom lane