Skip site navigation (1) Skip section navigation (2)

Re: Missing tables in tree

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Howard Hansen " <howardh(at)halfmagic(dot)com>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Missing tables in tree
Date: 2004-01-27 16:22:12
Message-ID: 03AF4E498C591348A42FC93DEA9661B872062D@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: Howard Hansen [mailto:howardh(at)halfmagic(dot)com] 
> Sent: 27 January 2004 16:00
> To: pgadmin-support(at)postgresql(dot)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.

pgadmin-support by date

Next:From: Justin WalshDate: 2004-01-28 05:00:46
Subject: Re: pgadmin 3 on SUSE linux 9.0
Previous:From: Howard Hansen Date: 2004-01-27 16:00:01
Subject: Missing tables in tree

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group