| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Simon Wittber <simonwittber(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: relation does not exist error |
| Date: | 2004-12-03 03:18:54 |
| Message-ID: | 20041203031854.GA32151@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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;
> ERROR: relation "customers" does not exist
See the "Identifiers and Key Words" section in the "SQL Syntax" of
the PostgreSQL documentation. Pay particular attention to what it
says about case sensitivity, case folding, and quoting of identifiers.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2004-12-03 03:22:11 | Re: relation does not exist error |
| Previous Message | Simon Wittber | 2004-12-03 03:01:16 | relation does not exist error |