Re: Postgres not finding tables

James Hall <James.Hall@RadioShack.com> writes:
> Recently I noticed that postgres gives the error:
> "Couldn't find any tables, sequences or indices!"
> whenever I tried '\d' or '\d*' on one of the machines.  BUT the
> database DOES contain tables because I can execute
> 'select * from testtable;' and postgres will display the table info.

(checks 6.5 psql sources...)  Back then, \d expanded to a query like

    SELECT usename, relname, relkind, relhasrules
    FROM pg_class, pg_user
    WHERE usesysid = relowner AND (other conditions)

This will miss any tables for which there is no matching owner listed
in pg_user.  I'm guessing that's your problem ... how you got into that
state I don't know, but look at table ownership.

            regards, tom lane