From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | <mobilepc(at)mobilepcclinic(dot)net>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Autonumbering Problem? |
Date: | 2006-08-21 16:52:39 |
Message-ID: | C10F5D17.FD77%sdavis2@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 8/21/06 12:51 PM, "Arthur Baldwin" <mobilepc(at)mobilepcclinic(dot)net> wrote:
> Hi,
>
> I'm used to MS Access handling the autonumbering all by itself. I'm not
> sure if this issue is common knowledge for both PostGres and MySQL, but
> perhaps the reason for my error message has to do with a badly formed
> SQL statement. Here is the output seen in my terminal window:
>
> [arthur(at)arthur ~]$ psql tco
> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> 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)
Postgresql is case-sensitive. Try:
insert into "Customers" (FullName) values ('Arthur E. Baldwin');
Note that you have to use double quotes to ensure that the names are not
case-folded to lower case.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Witney | 2006-08-21 16:56:52 | Re: Autonumbering Problem? |
Previous Message | Arthur Baldwin | 2006-08-21 16:51:20 | Autonumbering Problem? |