"Joe DeBrunner" <jdebrunner(at)NO_SPAMyahoo(dot)com> writes:
> For some reason I can no longer see all of the databases in Postgresql. When
> I am in psql and type \l I only see template1. I can \c to connect to the
> databases but they will not list. Same thing with tables. The tables are
> there, but I cannot \dt to list them.
> Any idea what might cause this?
You probably deleted the pg_shadow entries for the other databases'
owners.
regards, tom lane