| 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: | Whole Thread | Raw Message | 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 |