From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | Dale Seaburg <kg5lt(at)verizon(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Not able to find a table |
Date: | 2007-07-30 14:51:57 |
Message-ID: | 42B89BBF-A558-45CB-A689-0713B0E0A65A@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Jul 30, 2007, at 9:26 , 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.
SQL is case-insensitive unless the identifier is quoted. PostgreSQL
downcases unquoted identifiers, so
instrument_type
InSTrument_type
INSTRUMENT_TYPE
Instrument_Type
all are treated as instrument_type.
Note that \d returns "Instrument_Type". This means the identifier was
quoted when created. "Instrument_Type" is not the same as
Instrument_Type or instrument_type. You need to quote the identifier
to use it, e.g.,
SELECT *
FROM "Instrument_Type";
Michael Glaesemann
grzm seespotcode net
From | Date | Subject | |
---|---|---|---|
Next Message | Dale Seaburg | 2007-07-30 15:45:45 | Re: Not able to find a table |
Previous Message | Michael Fuhr | 2007-07-30 14:43:51 | Re: Not able to find a table |