Autonumbering Problem?
От | Arthur Baldwin |
---|---|
Тема | Autonumbering Problem? |
Дата | |
Msg-id | 1156179080.3275.4.camel@arthur.tco обсуждение исходный текст |
Ответы |
Re: Autonumbering Problem?
Re: Autonumbering Problem? Re: Autonumbering Problem? |
Список | pgsql-novice |
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@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) tco=# What am I doing wrong?
В списке pgsql-novice по дате отправления: