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

Re: ERROR: 42P01: relation "<tableName" does not exist"

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: bob_a(at)xypro(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: 42P01: relation "<tableName" does not exist"
Date: 2005-09-06 04:52:08
Message-ID: 20050906045207.GA95353@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, Sep 02, 2005 at 03:41:43PM -0700, bob_a(at)xypro(dot)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

In response to

pgsql-novice by date

Next:From: Pradeepkumar, Pyatalo (IE10)Date: 2005-09-06 06:35:08
Subject: Libpq - multibyte character support
Previous:From: Michael FuhrDate: 2005-09-06 04:11:51
Subject: Re: Last Id?

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