Dale Seaburg wrote:
> I have a database that can be accessed and used correctly via ODBC
> and MS-Access. But when I try to do a simple SQL SELECT query in
> psql, I get an error that the table can't be found: Relation
> "instrument_type" does not exist. Yet, when I do a "\d" command, I
> see the table named "Instrument_Type" in the "public" schema. I use
> the database owner as the user id for psql.
> I need some help where to look in, say pgAdmin III (my tool of choice
> for database creation / maintenance) for a clue as to why I am
> getting this error.
> Thanks for any help, ideas, clues, starting points.
select * from "Instrument_Type" limit 10;
in psql. The problem is that for unquoted table names, postgres
automatically lower-cases everything. To access tables with upper case
letters in their names, you need to quote them (using " quotes).
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2007-07-30 14:43:51|
|Subject: Re: Not able to find a table|
|Previous:||From: Dale Seaburg||Date: 2007-07-30 14:26:58|
|Subject: Not able to find a table|