Roy Souther <roy@silicontao.com> writes:
> But I can do "SELECT * FROM a_bad_table" and I see all the data, it is there.
> But also when I do "SELECT * FROM pg_tables WHERE tablename = 'a_bad_table'"
> I get nothing, it is not in the tables table.
pg_tables is just a view, and it filters out stuff that it thinks is a
view or otherwise not a plain table. What do you see if you look in
pg_class?
regards, tom lane