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
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 |