This is a discussion on ERROR: relation "managers" does not exist within the pgsql Novice forums, part of the PostgreSQL category; --> While trying to INSERT INTO managers table I get the following message: ERROR: relation "managers" does not exist What ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend |
| ||||
| 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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org |