Thread: Missing tables in tree

Missing tables in tree

From
"Howard Hansen "
Date:
Love pgAdmin, but I've run into a problem since moving my server from my
internal network to one hanging off of the Internet directly.  On the
client, I'm running pgAdmin 1.6.0 with psqlODBC 7.3.100.  Server-side, it's
PostgreSQL 7.3.4 on a Debian Woody box.

Previously, I would connect to the server, see a list of the databases, then
when I clicked on one and expanded it in the tree, I would see all manner of
cool things including Tables.  No longer.  I see only Casts, Languages, and
Schemas.  The logged-in user is defined as:

CREATE USER username WITH SYSID 103 CREATEDB CREATEUSER VALID UNTIL
'2006-01-17 00:00:00';

I've tried about a dozen Google queries, but I haven't found the magic one
yet.

I don't mean to complain, but Casts, Languages, and Schemas are not nearly
as useful to me as -- say -- Tables, Indexes, and Sequences.  Any and all
help, pointers, or even sympathy will be greatly appreciated.

Please cc me on replies, since I'm not on the list.  Thanks!

Howard Hansen
http://justenoughlinux.com
(206) 992-1348





Re: Missing tables in tree

From
"Dave Page"
Date:

> -----Original Message-----
> From: Howard Hansen [mailto:howardh@halfmagic.com]
> Sent: 27 January 2004 16:00
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Missing tables in tree
>
> Love pgAdmin, but I've run into a problem since moving my
> server from my internal network to one hanging off of the
> Internet directly.  On the client, I'm running pgAdmin 1.6.0
> with psqlODBC 7.3.100.  Server-side, it's PostgreSQL 7.3.4 on
> a Debian Woody box.
>
> Previously, I would connect to the server, see a list of the
> databases, then when I clicked on one and expanded it in the
> tree, I would see all manner of cool things including Tables.
>  No longer.  I see only Casts, Languages, and Schemas.  The
> logged-in user is defined as:
>
> CREATE USER username WITH SYSID 103 CREATEDB CREATEUSER VALID UNTIL
> '2006-01-17 00:00:00';
>
> I've tried about a dozen Google queries, but I haven't found
> the magic one yet.
>
> I don't mean to complain, but Casts, Languages, and Schemas
> are not nearly as useful to me as -- say -- Tables, Indexes,
> and Sequences.  Any and all help, pointers, or even sympathy
> will be greatly appreciated.
>
> Please cc me on replies, since I'm not on the list.  Thanks!

Expand schemas - in PostgreSQL 7.3+ tables etc. all live in a schema.

Regards, Dave.