Skip site navigation (1) Skip section navigation (2)

Re: Not able to find a table

From: Michael Fuhr <mike(at)fuhr(dot)org>
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:43:51
Message-ID: 20070730144351.GA21069@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, Jul 30, 2007 at 09:26:58AM -0500, 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.

See "Why are my table and column names not recognized in my query?
Why is capitalization not preserved?" in the FAQ and "Identifiers
and Key Words" in the documentation, in particular the part that
discusses quoted identifiers and case sensitivity:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.21
http://www.postgresql.org/docs/8.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

-- 
Michael Fuhr

In response to

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2007-07-30 14:51:57
Subject: Re: Not able to find a table
Previous:From: Brian HurtDate: 2007-07-30 14:41:13
Subject: Re: Not able to find a table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group