On Thu, 18 Sep 2003, Josh Eno wrote:
> The reason I'd never noticed the table is because in doing a \d it
> doesn't show up in the table list. If I try to do a \d TABLE_NAME, I
> can use <tab> to autocomplete the name, but then it says the table
> doesn't exist. I can't select any of those 40,000 rows while I'm in the
> database, and I can't drop it, either. The only evidence of the table I
> can find while I'm actually in the database is by doing a select * from
> pg_tables, and it shows up as the following:
You need to say things like:
select * from "ROOT_U_QUICK_LOOKUP"
(note the double quotes to prevent casefolding).
It's interesting that \d FOO
gives an error message referencing "FOO"
since it's actually looking for a table that's been
case-folded. I think the error message is incorrect.
In response to
pgsql-bugs by date
|Next:||From: Edmund Bacon||Date: 2003-09-19 21:45:59|
|Subject: create temporary sequence and ecpg|
|Previous:||From: Jean-Luc Lachance||Date: 2003-09-19 14:43:52|
|Subject: Re: select where id=random()*something returns two results|