Listing tables - why doesn't it work? <sob>

From: Walt Weaver <wweaver(at)rightnow(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Listing tables - why doesn't it work? <sob>
Date: 2001-02-09 17:01:18
Message-ID: 3A8423AB.3CDA78BA@rightnow.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm having a problem listing tables in my Postgres database.

I log in as superuser (i.e., psql rnw_hosted), and can describe the
tables individually, as \d error_type. There are a total of six tables
in the database, and I can access each one individually. But, when I do
a \dt, only one table is listed. Likewise, when I try to do a backup
using pg_dumpall, it complains because it can't find one of the tables.

Is this some kind of permissions problem?

Oh, and one more question: how can I query the system catalog tables?
The documentation mentions a syscat.source file in the src/tutorial
directory, but I haven't been able to find this directory anywhere on
the server.

We're running Postgres v.7.0 here.

Thanks,
--Walt Weaver
Bozeman, Montana

Browse pgsql-general by date

  From Date Subject
Next Message Jose solo en casita 2001-02-09 17:29:35 Re: 4GL on Postgresql ?
Previous Message Walt Weaver 2001-02-09 16:54:22 Starting postmaster in logging mode