Jason Whitener <jwhitene@pcc.edu> writes:
>> Well, that's what I'd expect to see --- but the prompt indicates that you
>> did this in the "postgres" database, which is not where you're having the
>> problem. We need to look at the public schema within the mypcc database.
> Oops. Here's the mypcc database.
> psql mypcc mypcc
> mypcc=> select * from pg_namespace where nspname = 'public';
> nspname | nspowner | nspacl
> ---------+----------+------------------------
> public | 10 | {postgres=UC/postgres}
> (1 row)
Ah-hah, as I rather suspected: public access to the "public" schema has
been revoked. (There's some info in the GRANT man page about reading
ACL displays, if you're not sure how to interpret the above.)
> mypcc=> \dt
> No relations found.
The reason for these odd behaviors is that unreadable schemas get dropped
out of your search_path (rather than throwing errors). So the tables are
there, but unless you're superuser you can't get at them.
I'd suggest a "GRANT ALL ON SCHEMA PUBLIC TO PUBLIC".
It's still unclear how you got those permissions revoked, but it seems
pretty clear that you didn't really want to do that.
regards, tom lane