Re: Autonumbering Problem?

> 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.