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.