The answer is in the question! It's the difference between Customers
and customers.
PostgreSQL folds identifiers to lower case if not double quoted.
The best solution is to use lower case consistently. The alternative is
to use double quotes consistently.
Try SELECT * FROM "Customers"; and you
Wow, 4 responses in 10 minutes to my newbie question. Thanks guys.
I'm coming from a SQL Server background, so quoting table names didn't
immediately spring to mind.
I can see support will not be a problem. 10 out of 10.
Sw.
---(end of broadcast)-
Simon Wittber <[EMAIL PROTECTED]> writes:
> WMSDV=# \dt
> List of relations
> Schema | Name| Type | Owner
> +---+---+---
> public | Customers | table | simon
> public | Persons | table | simon
> (2 rows)
>
> WMSDV=# select * from Customers;
> ERROR: re
On Fri, Dec 03, 2004 at 11:01:16AM +0800, Simon Wittber wrote:
> List of relations
> Schema | Name| Type | Owner
> +---+---+---
> public | Customers | table | simon
> public | Persons | table | simon
> (2 rows)
>
> WMSDV=# select * from Customers;
> ER
I'm evaluationg PostgreSQL 8.0 beta 5 for a new development project.
I've created a user 'simon' and a database named 'WMSDV'.
I've created some tables (see below) and assigned arwdRxt privledges
to the 'simon' user.
However, when i use psql, I am unable to select these tables. I
receive a 'rela
"Rob Klaus" <[EMAIL PROTECTED]> writes:
> We are having a problem where intermittently a query will not work,
> returning an error:
> ERROR: Relation "x" does not exist
> It will do this for a variable period, typically not lasting more than 5
> minutes
This certainly seems like a bug, but I have
ECTED]
Subject: Re: [GENERAL] Relation does not exist
"Rob Klaus" <[EMAIL PROTECTED]> writes:
> We are having a problem where intermittently a query will not work,
> returning an error:
> ERROR: Relation "x" does not exist
> It will do this for a variable period,
