Re: ERROR: relation "managers" does not exist

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Mark Edward Smith <mark(at)markedwardrisk(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: relation "managers" does not exist
Date: 2004-12-31 04:06:36
Message-ID: 20041231040636.GA95582@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Dec 30, 2004 at 03:31:34PM -0800, Mark Edward Smith wrote:

> While trying to INSERT INTO managers table I get the
> following message:
>
> ERROR: relation "managers" does not exist

Are you sure the table exists? What does \dt show? Does the table
name have uppercase letters? If so, then you'll have to quote it --
see "Identifiers and Key Words" in the "SQL Syntax" chapter of the
documentation.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2004-12-31 05:38:08 Re: adding a new data to existing psql table from comma del file
Previous Message Mark Edward Smith 2004-12-30 23:31:34 ERROR: relation "managers" does not exist