Re: Autonumbering Problem? - Mailing list pgsql-novice

From Adam Witney
Subject Re: Autonumbering Problem?
Date
Msg-id 44E9E5D4.70706@sgul.ac.uk
Whole thread Raw
In response to Autonumbering Problem?  (Arthur Baldwin <mobilepc@mobilepcclinic.net>)
List 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.


pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Autonumbering Problem?
Next
From: Andreas
Date:
Subject: invalid byte sequence ?