Postgres Pro
Downloads
Home   >   mailing lists

Re: psql \l problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: psql \l problem
Date
Msg-id 1218.1002916236@sss.pgh.pa.us
Whole thread Raw
In response to psql \l problem  ("Joe DeBrunner" <jdebrunner@NO_SPAMyahoo.com>)
List pgsql-admin
Tree view 
"Joe DeBrunner" <jdebrunner@NO_SPAMyahoo.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

pgsql-admin by date:

Previous
From: Orion
Date:
Subject: Index Scans Oddness
Next
From: "Brett W. McCoy"
Date:
Subject: Re: Permission Denied When i am Trying to take Backup