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: (view raw or whole 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.

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-2015 The PostgreSQL Global Development Group