From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | mobilepc(at)mobilepcclinic(dot)net |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Autonumbering Problem? |
Date: | 2006-08-21 16:56:52 |
Message-ID: | 44E9E5D4.70706@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> tco=# insert into customers (FullName) values ('Arthur E. Baldwin');
> ERROR: relation "customers" does not exist
> tco=# \d
> List of relations
> Schema | Name | Type | Owner
> --------+----------------------+----------+--------
> public | Customers | table | arthur
> public | Customers_CustID_seq | sequence | arthur
> (2 rows)
>
> tco=#
>
> What am I doing wrong?
the table in your database has a capital 'C'. I'm guessing your table
fields have capitals as well, so try this
tco=# insert into "Customers" ("FullName") values ('Arthur E. Baldwin');
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2006-08-21 17:40:12 | invalid byte sequence ? |
Previous Message | Sean Davis | 2006-08-21 16:52:39 | Re: Autonumbering Problem? |