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
