Home > mailing lists

Table access - Mailing list pgsql-novice

From	Peter Rodriguez
Subject	Table access
Date	January 17, 2001 16:17:52
Msg-id	3A650796.49B4291E@attglobal.net Whole thread Raw
List	pgsql-novice

Tree view

I have installed PostgreSQL 6.5.3 on my stand-alone i686-pc-linux-gnu machine (RedHat 6.2), compiled by gcc egcs-2.91.66

I have created tables both using the interactive sql monitor and using PGaccess GUI. The command "\dt" in the interactive monitor yields the expected list of tables, but "select * from foo" yields "ERROR: foo: Table does not exist" for all tables created through the GUI, but is OK with tables created in the interactive monitor. Using the GUI I can access all tables without problems.
Can anyone tell me what is going on here? I sould be much obliged

-- 
Peter Rodriguez 
2/219, St. George Street, Papatoetoe     
Auckland, NEW ZEALAND

pgsql-novice by date:

From: Tom Lane
Date: 17 January 2001, 15:01:12
Subject: Re: LIKE optimization

From: Laurel Williams
Date: 17 January 2001, 17:05:59
Subject: Postgres superuser & password on Red Hat; upgrade?

Table access - Mailing list pgsql-novice

Previous

Next