altering a table to set serial function

Поиск
Список
Период
Сортировка
От Prabu Subroto
Тема altering a table to set serial function
Дата
Msg-id 20040727171611.43604.qmail@web41804.mail.yahoo.com
обсуждение исходный текст
Ответы Re: altering a table to set serial function
Re: altering a table to set serial function
Список pgsql-general
Dear my friends...

I am using postgres 7.4 and SuSE 9.1.

I want to use auto_increment as on MySQL. I look up
the documentation on www.postgres.com and I found
"serial" .

But I don't know how to create auto_increment.
here is my try:
"
kv=# alter table sales alter column salesid int4
serial;
ERROR:  syntax error at or near "int4" at character 40
"

Please tell me the correct command to that.

Thank you very much in advance.



__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Trigger on Postgres for tables syncronization
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Trigger on Postgres for tables syncronization