One other thing I've just thought of, if you issue a manual query from
within pgAdmin - does this succeed?
Also roughly how big are the tables (i.e. number of rows) - does it help
if you set a LIMIT in the SQL clause (by default I think it's 1000 rows
but try setting a LIMIT of 1 row and see if that comes back.)
Andy.
Jeanna Geier wrote:
> Thanks for the reply, Andy.
>
> No, no error from pgadmin, and, yes, I can see all the properties of the
> tables before opening it. You can open the tables and see menu bars and
> what-not, just no data in the tables/views, but like I said, I know the data
> is in there, because I can access it using psql from the command line.
>
> We haven't tried any other client tools, but I'll give that a try, thanks.
> And, if that doesn't help, I'll take your suggestion of asking on
> pgadmin-support.
>
> Thanks again!!
> -Jeanna
>