Skip site navigation (1) Skip section navigation (2)

Re: Autonumbering Problem?

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 (view raw or flat)
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.


In response to

pgsql-novice by date

Next:From: AndreasDate: 2006-08-21 17:40:12
Subject: invalid byte sequence ?
Previous:From: Sean DavisDate: 2006-08-21 16:52:39
Subject: Re: Autonumbering Problem?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group