Re: ERROR: 42P01: relation "

From Michael Fuhr
Subject Re: ERROR: 42P01: relation "
Date
Msg-id 20050906045207.GA95353@winnie.fuhr.org
Whole thread Raw
In response to ERROR: 42P01: relation "  (bob_a@xypro.com)
List pgsql-novice
On Fri, Sep 02, 2005 at 03:41:43PM -0700, bob_a@xypro.com wrote:
> select * from pwInfo
> ERROR:  relation "pwinfo" does not exist

Unquoted identifiers are folded to lowercase, so if you created the
table with mixed-case letters then you'll have to quote the table
name.  For more information see "Identifiers and Key Words" in the
"SQL Syntax" chapter of the documentation.

http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Last Id?
Next
From:
Date:
Subject: Re: Last Id?