Re: Postgres not finding tables

James Hall <James(dot)Hall(at)RadioShack(dot)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