Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: relation "managers" does not exist - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: ERROR: relation "managers" does not exist
Date
Msg-id 20041231040636.GA95582@winnie.fuhr.org
Whole thread Raw
In response to ERROR: relation "managers" does not exist  (Mark Edward Smith <mark@markedwardrisk.com>)
List pgsql-novice
Tree view 
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/

pgsql-novice by date:

Previous
From: "sloftus"
Date:
Subject: adding a new data to existing psql table from comma del file
Next
From: Michael Fuhr
Date:
Subject: Re: adding a new data to existing psql table from comma del file