Mihai Tanasescu <Mihai(dot)Tanasescu(at)skyraven(dot)pcnet(dot)ro> writes:
> If I login with user bbstatus to database bbstatus then I can do a
> "\dt" and show the tables it contains but if I login with user postgres
> which is a superuser and I try a "\dt" I get no results.
It's got nothing to do with permissions --- it has to do with your
search path. Schema bbstatus isn't in postgres' default search path
and so by default \dt doesn't show its contents.
You could see 'em with \dt *.* or \dt bbstatus.*, or you could set
search_path to include bbstatus.
regards, tom lane