Thread: ERROR: relation "managers" does not exist

ERROR: relation "managers" does not exist

From
Mark Edward Smith
Date:
While trying to INSERT INTO managers table I get the
following message:

ERROR:  relation "managers" does not exist

What is this? And how do I make it go away?

Thanks for you help.

Mark




Re: ERROR: relation "managers" does not exist

From
Michael Fuhr
Date:
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/